Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Show Year over Year Difference in Tooltip

I had a requirement where I need to show Month over Month Difference when the user hovers over a month in my line chart.

This was answered here :

https://community.qlik.com/t5/New-to-Qlik-Sense/Show-Month-over-Month-Difference-in-Tooltip/m-p/2066...

But now, the user also wants to see Year over Year difference along with the Month over Month. When I changed Month fields used in the calculation with year-month, it did not work and shows the same values as Month over Month.

MoM Difference : count({<Month>}distinct [Customer ID]) - Above(count({<Month>}distinct [Customer ID]), 1)

Tried Year over Year difference: count({<Year>}distinct [Customer ID]) - Above(count({<Year>}distinct [Customer ID]), 1)

Both give MoM but not Year over Year.

Labels (5)
4 Replies
Rohan
Specialist
Specialist

Hi,

You will have to create a cumulative sum column in the back end  data model or use Rangesum instead of only sum. Because the values will be aggregated based on the Month level, Even if you put Year in your set, it will only show that Month's value.

Hope this pushes you to your required output, Kindly let me know.

Thanks & Regards,

Rohan.

qlikwiz123
Creator III
Creator III
Author

Hi @Rohan 

Not sure how that works since mine is a count and RangeSum is for Sum. And looking at the backend data model, again, there is no appropriate function to calculate Y0Y Difference. Kindly suggest a calculation that can be used on either front end or backend

Rohan
Specialist
Specialist

Hi,

Please check nested aggregation, for eg: rangesum(aggr(count(),Month)). This will help you cumulate the monthly values.

 

Thanks & Regards,

Rohan.

qlikwiz123
Creator III
Creator III
Author

Hi,

 

Tried this and is not working. Giving me large incorrect numbers.