topic Re: partial sum in pivot table in QlikView

partial sum in pivot table

tyagishaila — Fri, 20 Feb 2015 05:47:39 GMT

Hi,

I have a requirement in my pivot table that label of partial sum should be dynamic.

To clear my problem I have attached an image, in this

I need Sub Total BEAUTY

Sub Total CHILDRENSWEAR and so on...

in place of Sub Total.

Thanks,

Shaila

robert_mika — Fri, 20 Feb 2015 06:13:19 GMT

Try this topic:

tyagishaila — Fri, 20 Feb 2015 06:23:35 GMT

Thanks for your quick response Mika.

But I have huge data Both row wise and column wise.

Use of CustomTotals and Concatenate(CustomeTotals) will take more efforts.

Dimension1

Dimension2

...

DimensionN

same has to repeat for all rows.

is a very lengthy process ...

Regards,

Shaila

anbu1984 — Fri, 20 Feb 2015 06:25:06 GMT

Anonymous — Fri, 20 Feb 2015 06:27:11 GMT

Shaila can you attache your sample application ... so that resolution will be easy to explain.

tyagishaila — Fri, 20 Feb 2015 07:00:08 GMT

HI Balkumar,

My application load data from my local machine. how will you open it on your machine.

Anonymous — Fri, 20 Feb 2015 07:04:59 GMT

Just load it and attache .. it will work .

tyagishaila — Fri, 20 Feb 2015 07:14:38 GMT

I have attached qvw file.

Please find the solution.

Thanks

Anonymous — Fri, 20 Feb 2015 07:36:53 GMT

I think this document is corrupted can you upload it again