topic set analysis expression help? in QlikView

set analysis expression help?

Vidit — Wed, 13 Jul 2016 11:46:13 GMT

Hi,

What should be changed in the following set analysis expression, that the count for previous quarter also changes with select in DIV field?

expression used

sum({$+1<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}Count)

Please suggest?

Chanty4u — Wed, 13 Jul 2016 11:58:53 GMT

try

sum({$+1<[Prod] = {'D'},PeriodNum={"$(=Max(PeriodNum)-1)"}>}Count)

Vidit — Wed, 13 Jul 2016 12:04:16 GMT

The expression I have mention is working the issue is for

<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}

this part of expression it doesn't work for DiV filter

rubenmarin — Wed, 13 Jul 2016 12:09:55 GMT

Hi Vidit, can you try?:

sum({$+1<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}, DIV=P(DIV)>}Count)