topic Re: Pivot table issue help in QlikView

Pivot table issue help

Wed, 25 Nov 2020 16:16:04 GMT

I have attached test QVW and the excel file.

I have 3 expressions but I dont want to show total on each Status level insted I only want the total of those expresions at the end as attached screenshot.How can I do that ?

Re: Pivot table issue help

martinpohl — Tue, 09 Aug 2016 18:23:57 GMT

so uncheck the subtotal on dimension 3

regards

Re: Pivot table issue help

Tue, 09 Aug 2016 18:28:36 GMT

The second column is calculated based on the expressions...unchecking doesnt help.

Re: Pivot table issue help

Tue, 09 Aug 2016 19:15:52 GMT

stalwar1‌ Do you have any solution as always please

Re: Pivot table issue help

sunny_talwar — Tue, 09 Aug 2016 23:34:04 GMT

See if this helps

Re: Pivot table issue help

vishsaggi — Wed, 10 Aug 2016 00:01:57 GMT

Hi sunny, this is very interesting showing multiple subtotals/totals in the last for a pivot table. I am trying to get my head around this, if not much pain would mind explaining the below stuff a little more :

1. Two tables created with Dim and Dim2?

2. =Pick(Dim2, PSSiteSubmittalStatus, 'Total') ?

3. =If(Dim2 = 2, Pick(Dim, 'Total', 'ATT', 'VERIZON'), '') ?

Apologies if I am asking too basic ?

Thanks,
V.

Re: Pivot table issue help

sunny_talwar — Wed, 10 Aug 2016 00:23:20 GMT

Vish -

Right now I am trying to get something done, but I promise to go over this (either here or a blog post) to explain the logic behind what I have done.

Best,

Sunny

Re: Pivot table issue help

vishsaggi — Wed, 10 Aug 2016 00:32:46 GMT

No problem, appreciate that.

Thanks,
V.

Re: Pivot table issue help

Wed, 10 Aug 2016 01:36:29 GMT

Perfect.Thank again.One question...how can I have total as last row after ATT and Verizon row ?

Re: Pivot table issue help

sunny_talwar — Wed, 10 Aug 2016 01:39:02 GMT

Made the modification to the dimension and the expression

Re: Pivot table issue help

Wed, 10 Aug 2016 01:47:49 GMT

Thank you very much . I am always thankful to you.

Re: Pivot table issue help

sunny_talwar — Wed, 10 Aug 2016 01:49:18 GMT

No problem my friend

I am glad I am able to help

Re: Pivot table issue help

Wed, 10 Aug 2016 02:02:07 GMT

You are really great.You are very kind..Stay blessed.