Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
coco_manel
Contributor II
Contributor II

YTD for multipl years

Hello, i want in a bar char to show the profit over year month dimension. also i made a button to select YTD calculation, but the problem is that when i select two years for example instead of showing YTD for each year it cumulates and shows the wrong value. Do you know what should i add into the set expression in such way that once that i select two years after ending the first one in the bar chart then the second starts over again and it calculates the YTD? Thank you! 😄

Labels (3)
1 Reply
hic
Former Employee
Former Employee

If you have YearMonth as first dimension, you could have Year as second dimension. Then it should restart automatically.

For additional ideas on how to visualize data over several years, take a look at:
https://community.qlik.com/t5/Design/Year-over-Year-Comparisons/ba-p/1462927
https://community.qlik.com/t5/Design/Cyclic-or-Sequential/ba-p/1467402
https://community.qlik.com/t5/Design/Relative-Calendar-Fields/ba-p/1473620