Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Pivot table issue help

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 ?

1 Solution

Accepted Solutions

Re: Pivot table issue help

See if this helps

Capture.PNG

View solution in original post

12 Replies
Partner
Partner

Re: Pivot table issue help

so uncheck the subtotal on dimension 3

regards

Not applicable

Re: Pivot table issue help

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

Not applicable

Re: Pivot table issue help

stalwar1‌ Do you have any solution as always please

Re: Pivot table issue help

See if this helps

Capture.PNG

View solution in original post

vishsaggi
Esteemed Contributor III

Re: Pivot table issue help

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

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

vishsaggi
Esteemed Contributor III

Re: Pivot table issue help

No problem, appreciate that.

Thanks,
V.

Not applicable

Re: Pivot table issue help

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

Re: Pivot table issue help

Made the modification to the dimension and the expression