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 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
tu_nguyen
New Contributor

Re: YoY Difference and Growth

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

2 Replies
isingh30
Contributor III

Re: YoY Difference and Growth

Please share your data in excel sheet or sample application.

Thank you!

tu_nguyen
New Contributor

Re: YoY Difference and Growth

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

Community Browser