Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparison in a pivot table

Hello,

I have this pivot table with montlhy sales and a total by year, now I want to compare for example january 2010 with december 2009, I'm using the Below() function, but when it reachs those months it doesn't work.

How can I do that?

Thank you.

1 Solution

Accepted Solutions
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

Use the total qualifier with Below:

Below(total expr)

Regards,

Stephen

View solution in original post

1 Reply
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

Use the total qualifier with Below:

Below(total expr)

Regards,

Stephen