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: 
Not applicable

two extra columns in pivot table

Hi,

I need two columns one is for DualYearDIff and the Other is TotalYearDiff

in those columns i need the difference of the values in 2013 and 2012 ie 2013-2012 =7096-964 = 6132

and 2014-2013 and 2012 should be empty because it has no previous value

the same procedure to the TotalYearDiff column as well

i am sharing the app

3 Replies
Not applicable
Author

Hope this is what you are looking for, attached QVW.

Regards,

Raksha

Not applicable
Author

I need like this

Capture.PNG.png

I need the Dual YOY to be like this but i hard coded the values here , i need them to be logical

Not applicable
Author

Is someone to suggest