Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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
isingh30
Specialist
Specialist

Please share your data in excel sheet or sample application.

Thank you!

Anonymous
Not applicable
Author

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))