Max week set analysis

klam0001 — Sun, 19 Aug 2018 09:10:50 GMT

Hi,

For my Dashboard KPI, I want to show the data of the current week regardless of any other selections made (this value should never change).

The following expression is what I used:

=Sum({1<_WeekSerial = {$(=max(_WeekSerial))}>} [Count])

I thought the set identifier {1} was used for this exact purpose, however when I select another month it will still take the last week of that month only. I'm guessing this is because of =max().

Is there another way to do it, without adding any variable or changing anything in the script.

Thanks!

Re: Max week set analysis

sunny_talwar — Mon, 20 Aug 2018 16:13:23 GMT

Try this

=Sum({1<_WeekSerial = {$(=max({1} _WeekSerial))}>} [Count])

Re: Max week set analysis

jmmolero — Mon, 20 Aug 2018 16:15:17 GMT

Hi,

add {1} to max(..):

Sum({1<_WeekSerial = {$(=max({1}[_WeekSerial]))}>} [Count])

topic Re: Max week set analysis in QlikView

Max week set analysis

Re: Max week set analysis

Re: Max week set analysis