Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tu_nguyen
New Contributor

YoY Difference and Growth

Hello everyone,

I'm looking for a method to visualize the difference between two years in a pivot table.

This is what I would like to get:

example.PNG

I tried this formula:

Sum( { $<[DocumentYear]={$(=max(DocumentYear))}>}  Revenue)

- Sum( { $<[DocumentYear]={$(=max(DocumentYear)-1)}>}  Revenue)

This is what I get:

example2.PNG

I guess each column filters the data for the choosen year and it is not possible to use the formula for my case.

Do you know a method for my case?

Thank you in advance!