topic Re: Addition to Pivot table in QlikView

Addition to Pivot table

upaliwije — Tue, 29 Aug 2017 16:27:55 GMT

Dear Friends

In the process of developing a Pivot table in my QV I find it difficult to add a few more columns to Pivot table

My original Pivot Table look like given below

I want to add 4 more columns (red)to calculate the growth and output table should look like in the screen shot below

Pls help me to do it.

My sample QV doc is also attached h/w

upaliwije — Wed, 30 Aug 2017 08:44:07 GMT

Can someone pls suggest possible way of doing the above even changing my data model

bharani8 — Wed, 30 Aug 2017 09:00:38 GMT

What is the logic u want to use for the Growth in ur data?

upaliwije — Wed, 30 Aug 2017 09:25:22 GMT

If you take top row

85-63=22(Nos Growth)

(22/63)*100 =35% Nos Gro %

That is logic Value as well

upaliwije — Wed, 30 Aug 2017 11:24:06 GMT

Hi Friends

I have tried and achieved my need and my out now is as shown below

Now I want to do some modification to the report.

I want to add Blank row in between two Prd Code

I want bold two rows ( NET PREMIUM and NET TOTAL)

Sample of the report is shown below. I am unable to the modification pls help me