Show Month over Month Difference in Tooltip

[qlikwiz123]

I have a Line Chart with Month-year as Dimension and Count(IDs) as Measure.

I would like to show Month over Month difference in the tool tip along with the count of IDs. How do I do that?

For example, if I hover over April 2023, the tooltip should show April Count(IDs) and difference in ID counts between March 2023 and April 2023

[Chanty4u]

You can try on custom tooltip option below expression 

RangeSum(Count(IDs) - Above(Count(IDs)),0)

[Prem0212 · Accepted solution]

you can try this expression and its working for me

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

Please like and accept the solution if you liked it.

[qlikwiz123]

@Prem0212 

What if I want to add Year over Year as a new tooltip? If a user points at March 2023, it should show difference between March 2022 and March 2023.

I tried substituting Month column with year but it is showing the same value as MoM