Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results 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:

I tried this formula:

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

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

But I don't get what I want:

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,

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

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

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

2 Replies
Specialist

Please share your data in excel sheet or sample application.

Thank you!

Anonymous
Not applicable
Author

Hey Ishtdeep Singh,