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: 
badamsrinivas
Contributor II
Contributor II

developemnts of app

Whenever user selects  any year value from filter pane, in dashboard should display that year and previous year data? how do you achieve it

Labels (2)
1 Reply
Vegar
MVP
MVP

You can achieve this by adjusting the measures used on the dashboard with set analysis  modifiers.

If your current dashboard  expression is SUM(Sales) then you can adjust which years that are taken into the calculation by adding a set modifier like this.

SUM({$<Year={">=$(=max(Year)-1)"}>}Sales)