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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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