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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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)