Missing Feature In Set Analysis

There needs to be a way to say “apply current selections, but ignore any selections in field A”. I submitted this as a feature request, but I hope someone from QlikTech sees this post. My proposed syntax is sum({$<!Year><!Month><!Week><!Date>} Sales). Otherwise, you need to use a positive assertion that lists each and every value, or calculates it on the fly. See my previous post and the use of concat() within a variable definition.

I guess I’ll eat those words. It seems, though I only have the beta and it may change, that to ignore selections in a given field, you can override the field value with an empty set. For example: sum({$<Year=>} Sales).

Related posts:

  1. QlikView 8.5 Introduces “Set Analysis”
  2. Seeing Dollar Signs in QlikView 8.5
  3. What’s “possible” in QlikView 9…
  4. Feedback For Expression Variables
  5. Create a Bullet Graph In QlikView + Video

This entry was posted in QlikView and tagged , . Bookmark the permalink.

6 Responses to Missing Feature In Set Analysis

  1. Henric Cronström says:

    It is even simpler than that… Try sum({$} Sales).

  2. Henric Cronström says:

    The formula above is wrong… It should be sum({$<Year=>} Sales)

  3. doron says:

    need help.
    i want that my sum func. will sum all values
    and ignore any selections except selection
    in one field.
    does it possible ?

    thx
    doron

  4. Sean says:

    I’m with doron, lets say i have the following simple dataset, Customer, Region, Product,Period,Sales

    i am wanting to write an expression that will ignore the selection on Region (if any) ie lets call it National Sales. take into consideration the selection on Customer, Product, Period

  5. JJ says:

    sum({Region={“*”}} NationalSales)

  6. doron says:

    thx to sean but i mean excatly on the contrary
    from your example.
    if i look on your example i want that the expration ignore any selection in any field but except selection on Region. if user select period and region the sales will calculate on all rows in any period but only row in the selected region.
    hope i cleared my point.
    thx
    doron

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>