topic Re: Sub total issue in Pivot table in QlikView

Sub total issue in Pivot table

kkkumar82 — Tue, 29 Dec 2015 12:53:36 GMT

Hi all,

I have a pivot table with two dimensions and one measure. Which looks like this.

Is there a way that I can add up the first two dimension values totals and display as below.

I am attaching a qvw file with sample data which may be useful. Also giving a table box which contains sample data.

Thanks

Kiran Kumar

Re: Sub total issue in Pivot table

kkkumar82 — Tue, 29 Dec 2015 13:22:50 GMT

Any work around from edit script??

Thanks

Kiran Kumar

Re: Sub total issue in Pivot table

lironbaram — Tue, 29 Dec 2015 13:24:07 GMT

you'll need to create

another dimension that group the two levels

have a look at the attach example

Re: Sub total issue in Pivot table

Tue, 29 Dec 2015 13:28:46 GMT

I've noticed you are grouping already by ProductRecordKey,

Why don't you create combined cost type in the script?

Re: Sub total issue in Pivot table

Tue, 29 Dec 2015 13:56:13 GMT

As Liron said, you will need to crate another dimension. I would suggest a method that is dynamic as possible. You may want to expand his solution to use nested 'If' in case you have more than the 2 types shown

Re: Sub total issue in Pivot table

kkkumar82 — Tue, 29 Dec 2015 14:37:17 GMT

Actually that key is a link to my fact table.

Thanks

Kiran Kumar

Re: Sub total issue in Pivot table

kkkumar82 — Tue, 29 Dec 2015 14:57:06 GMT

Hi Liron,

Thanks for your solution, the only problem I have in this solution is my customers are going to download the file where they will see an extra column( the first one ) for the whole data. In original the table is very huge.

Thanks

Kiran Kumar

Re: Sub total issue in Pivot table

kkkumar82 — Wed, 30 Dec 2015 09:12:21 GMT

Hi all ,

Finally I was able to crack this with the help of the following link,

Qlikview Subtotaling Customization: Part 2 |

the solution is almost same as of Liron but a data modeling change is additional.

Thanks all.

Kiran Kumar

Re: Sub total issue in Pivot table

kkkumar82 — Wed, 30 Dec 2015 09:27:22 GMT

I have also attached the final qvw with desired output.

Thanks

Kiran Kumar

Re: Sub total issue in Pivot table

Kushal_Chawda — Wed, 30 Dec 2015 10:31:27 GMT

Using some script & Front end you can do this like in attached