topic Re: Set analysis - ignores filters on list box in QlikView

Set analysis - ignores filters on list box

Thu, 04 Feb 2016 10:11:45 GMT

I have an expression in a text object, like below:

=num

(sum({$<PeriodCounter={">$(#=max(PeriodCounter-3))<=$(#=max(PeriodCounter)-2)"}, YearMonthNum=,Year=>}SickTime*+1)

sum({$<PeriodCounter={">$(#=max(PeriodCounter-3))<=$(#=max(PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1

, '# ##0,0%')

And when I do a selection in a list box for YearMonthNum I don't wont the expression to affect to expression.

I have try to include the field "YearMonthNum=" in the expression and also change $ to 1 but it does't work.

If I exlude the filter with PeriodCounter it works.

Any suggestions?

Re: Set analysis - ignores filters on list box

sunny_talwar — Thu, 04 Feb 2016 17:32:14 GMT

May be you needed it within the inner Max() function as well. Try this:

=Num

(Sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"},YearMonthNum=,Year=>}SickTime*+1)

sum({$<PeriodCounter={">$(#=max({<YearMonthNum, Year>}PeriodCounter-3))<=$(#=max({<YearMonthNum, Year>}PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1

, '# ##0,0%')

Re: Set analysis - ignores filters on list box

Gysbert_Wassenaar — Thu, 04 Feb 2016 17:33:21 GMT

Try addding it to the max functions too:

=num

(sum({$< PeriodCounter={">$(#=max({<YearMonthNum=,Year=>}PeriodCounter-3))<=$(#=max({< YearMonthNum>}PeriodCounter)-2)"},YearMonthNum=,Year=>}SickTime*+1)

sum({$<PeriodCounter={">$(#=max({<YearMonthNum,Year=>}PeriodCounter-3))<=$(#=max({<YearMonthNum,Year=>}PeriodCounter)-2)"}, YearMonthNum=,Year=>}WorkTime)+1

, '# ##0,0%')