# 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
Did you mean:
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:

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?

1 Solution

Accepted Solutions
Contributor

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

Thank you!

Contributor

Hey Ishtdeep Singh,