Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harsh44_bhatia
Creator
Creator

Difference Measure in a Pivot Table

Hello All,

I have a case with Pivot table where i need the difference between the Current Year and Prior Year values.

In my data model i have normalized the data set by Current year and Prior Year. So that i can use this flag to pivot in pivot table by writing just one expression. But along with this i also need difference between the prior and current year value.

i have attached a qvw file with pivot table and a straight table. i need something like the straight table but on a pivot table.

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi,

Check the attachment.

Capture.PNG

View solution in original post

3 Replies
Anonymous
Not applicable

What is the issue?

Change same Straight Table into Pivot Table??

tamilarasu
Champion
Champion

Hi,

Check the attachment.

Capture.PNG

harsh44_bhatia
Creator
Creator
Author

Thanks Tamil.