topic Re: Max not working with selections in QlikView

Max not working with selections

jpapador — Tue, 10 Feb 2015 22:30:07 GMT

I have an expression:

Sum({$<WeekYear={'$(=MaxString(WeekYear)-1)'}>} Duration)

Which works great at summing last weeks data. However if I make any selections in a date field the expression the expression stops working (just shows null).

I know Max(WeekYear)-1 works in a text box when I make selections but not in set analysis. What am I missing?

Re: Max not working with selections

Oleg_Troyansky — Tue, 10 Feb 2015 23:22:12 GMT

perhaps you should add Set Analysis modifiers to disregard calendar selections, if they mess up your logic?

Also, if your YearWeek is a string, then subtracting 1 can be tricky...

Re: Max not working with selections

Anonymous — Wed, 11 Feb 2015 04:26:08 GMT

Hi,

compare in number format.

HTH

Re: Max not working with selections

Wed, 11 Feb 2015 04:53:56 GMT

Hi ,

Could you post sample apps.

We can see the issue.

thanks

Re: Max not working with selections

Anonymous — Thu, 12 Feb 2015 15:40:16 GMT

try if this is what you want

I used additionally [Week of] in set Analysis

Regards