Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

YoY Difference and Growth

Hello everyone,

I'm looking for a method to visualize the YoY difference and growth in a pivot table.

For example:

example.PNG

I tried this formula:

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

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


But I don't get what I want:

example2.PNG

I think the problem is, that the pivot table filters the data for the years.

Do you know a method for this problem?

Thank you in advance!

1 Solution

Accepted Solutions
Contributor
Contributor

Hey Ishtdeep Singh,

thank you for your answer.

I already have found a solution for my problem. I used 'Before()'.

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

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

View solution in original post

2 Replies
Specialist
Specialist

Please share your data in excel sheet or sample application.

Thank you!

Contributor
Contributor

Hey Ishtdeep Singh,

thank you for your answer.

I already have found a solution for my problem. I used 'Before()'.

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

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

View solution in original post