Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
leomathew
Contributor

set analysis expression help?

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?

3 Replies
Chanty4u
Esteemed Contributor III

Re: set analysis expression help?

try

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

leomathew
Contributor

Re: set analysis expression help?

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

Re: set analysis expression help?

Hi Vidit, can you try?:

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