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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual indicator for select Year en Year-1

Hello,

I have an visual indicator(sum(sales)), i wnat to view sales for the select year end for the Year-1 in the same graphe(histogramme).

How can i do it?

Thanks

1 Reply
Not applicable
Author

Sum({<Year = {$(ONLY(Year))}>} Sales)
Sum({<Year = {$(ONLY(Year) - 1)}>} Sales)


That will work if you only have one year selected. If you're going to allow multiple year selections, it will be different (but then how do you define year -1).