topic Re: How to Create a % Change ROW in a Pivot table in QlikView

How to Create a % Change ROW in a Pivot table

jcampbell474 — Tue, 26 Sep 2017 13:49:38 GMT

I need to create a row that displays the 2016 vs. 2017, % Change, by month. I can calculate the % Change and put it in a column all day long, but do not know how to make it a row (for each Metric).

Here is a sample of what I need. I have the pivot table created, just need the % Change row in bold. What would be the best way to go about this?

Thanks in advance,

Jason

Re: How to Create a % Change ROW in a Pivot table

Anil_Babu_Samineni — Tue, 26 Sep 2017 13:51:07 GMT

He created sample Re: Percentage Subtotal

Re: How to Create a % Change ROW in a Pivot table

jcampbell474 — Tue, 26 Sep 2017 13:57:53 GMT

Thank you. That's very helpful, but doesn't fit my requirements. I need to get the % change per dimension value, not of all values (Grand Totals) and percent of total.

Thank you for the reference though, I can see it coming in handy at some point down the road.

- Jason

Re: How to Create a % Change ROW in a Pivot table

Anil_Babu_Samineni — Tue, 26 Sep 2017 13:59:28 GMT

May be share qvw file so then we can work for you

Re: How to Create a % Change ROW in a Pivot table

jcampbell474 — Tue, 26 Sep 2017 15:21:59 GMT

Okay, here is a sample. Thank you for the help!

Re: How to Create a % Change ROW in a Pivot table

sunny_talwar — Tue, 26 Sep 2017 15:26:33 GMT

Check attached

Re: How to Create a % Change ROW in a Pivot table

jcampbell474 — Tue, 26 Sep 2017 15:31:19 GMT

My goodness, Sunny. That was fast. It looks to be exactly what I need! Going to spend some time figuring out what it does and implement it into the application. Will let you know if I run into anything.

Thank you!

Re: How to Create a % Change ROW in a Pivot table

sunny_talwar — Tue, 26 Sep 2017 15:34:33 GMT

There is this other option... but then the % change is highlighted in gray