topic Re: How to disregarding any selection on expression? in QlikView

How to disregarding any selection on expression?

Thu, 31 Oct 2013 18:10:16 GMT

Hello,

how do I not consider selections month and year in the formula below, using Set Analysis? Thank you.

=num(if( Aggr(Rank(Sum(Value)),Year,Month) <= 3, sum(Value)) / 100,'#.##0M')

jaimeaguilar — Thu, 31 Oct 2013 18:26:17 GMT

Hi,

it is possible to disregard selections made by user with this syntax:

=num(if(Aggr(Sum(Value)), Year, Month) <= 3, sum({$<Month=, Year=>} Value)) / 100, '#,##0M')

Month= and Year = inside Set analysis will cause that selections on those fields will be ignored.

As a note, it is possible that this set analysis also has to be included in the if statement.

Regards

Thu, 31 Oct 2013 18:33:38 GMT

I tried this before, and still consider the Month dimension selection....

jaimeaguilar — Thu, 31 Oct 2013 18:43:56 GMT

Have you tried putting set analysis also in the if Statement?

=num(if(Aggr(Sum({$<Month=, Year=>} Value)), Year, Month) <= 3, sum({$<Month=, Year=>} Value)) / 100, '#,##0M')