Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in set analysis

This the scenario:
i've a table containg columns lets say...

DATE     Prev DATE      AMT

i want a chart displayin two bar graphs:

1)  AMT for current selection DATE

2) AMT for DATE=Current selection Prev DATE

how can we achive the second expression using set analysis method... ???

1 Reply
Michiel_QV_Fan
Specialist
Specialist

Please try this:

sum({$<Date = p({$<PrevDate>}Date)>}AMT)