topic Respect Selections Before Set Analysis Applied in QlikView

Respect Selections Before Set Analysis Applied

Wed, 13 Apr 2011 18:09:33 GMT

Is there a way to respect the selections made before applying the set analysis rules?

Respect Selections Before Set Analysis Applied

Wed, 13 Apr 2011 18:20:01 GMT

Kristy,

The set identifiers identify what record set the set analysis is based on:

$ = the records of the current selection

1= the full set of all the records in the application

take a look at the manual for some examples

Regards,

Gordon

Respect Selections Before Set Analysis Applied

Wed, 13 Apr 2011 18:26:52 GMT

I understand the use of $ and 1. However, the problem I am trying to solve is this... If my set analysis restricts to a specific filter (ie. date = 1/1/2011) and I make a date selection that is not 1/1/2011, I want my results to return null, 0, blank, or something other than the results for 1/1/2011 respecting the date selection.

Respect Selections Before Set Analysis Applied

erichshiino — Thu, 14 Apr 2011 18:39:54 GMT

Hi, Kristy

In this case set analysis would be an AND operation. You can use the *=

In the following expression you get the sales acoording to user selection only if they are also from John or Peter. If you your selections does not include John or Peter you will get 0.

sum({<[SalesMan] *={John,Peter}>} AMOUNT)

Hope it helps!

Regards,

Erich

Respect Selections Before Set Analysis Applied

Thu, 14 Apr 2011 19:40:59 GMT

Thank you. I think I can use this logic to accomplish what I need.