topic Re: Pivot Table Total in QlikView

Pivot Table Total

upaliwije — Tue, 29 Aug 2017 10:03:25 GMT

I have following pivot table in my Doc.

I want to add Grad total (BRAN+CITY) with Prd_code total also shown under the above table and output report should look llike the one given below

Is this possible if so pls advise me to how to do it. I have attached my sample QV doc

mayankraoka — Tue, 29 Aug 2017 10:06:22 GMT

Hi Upali,

Is this you are looking for?

PFA app

Another way is do inline load:

lOAD * INLINE [

Dept,Dept1

BRAN, BRAN,

CITY, CITY

BRAN, Total

CITY, Total

];

With appropriate ID and use Dept1 as field.

Regards,

Mayank

upaliwije — Tue, 29 Aug 2017 10:18:40 GMT

Hi Mayank

What I am looking for not Grand Total row but Prd_code wise grand total as shown in my 2nd screen shot

mayankraoka — Tue, 29 Aug 2017 10:35:34 GMT

Hi Upali,

Please check updated qvw this is what you want?

Regards,

Mayank

sunny_talwar — Tue, 29 Aug 2017 11:30:28 GMT

Another method

Add this to the script

Dim:

LOAD * Inline [

Dim

];

Dimensions

=Pick(Dim, DEPT, 'Total')

PRE_CODE

RISK_YEAR

Expression

COUNT(DISTINCT POLICY_NO)