Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vidit
Creator
Creator

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
MVP
MVP

try

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

Vidit
Creator
Creator
Author

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

Hi Vidit, can you try?:

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