topic Re: Difference Measure in a Pivot Table in QlikView

Difference Measure in a Pivot Table

harsh44_bhatia — Thu, 25 Feb 2016 01:22:13 GMT

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.

Re: Difference Measure in a Pivot Table

Anonymous — Thu, 25 Feb 2016 08:20:40 GMT

What is the issue?

Change same Straight Table into Pivot Table??

Re: Difference Measure in a Pivot Table

tamilarasu — Thu, 25 Feb 2016 08:23:29 GMT

Hi,

Check the attachment.

Re: Difference Measure in a Pivot Table

harsh44_bhatia — Thu, 25 Feb 2016 20:06:09 GMT

Thanks Tamil.