topic Re: Pivot Table - Show only Subtotal for Expression (Without Rows) in QlikView

Solved

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Solved

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

sunny_talwar — Tue, 07 Jun 2016 13:00:22 GMT

I really want to help, but I was not able to find the link to the previous discussions where me and others have provided a similar solution. May be kush7337‌ can help us find a previous discussion

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

Anonymous — Tue, 07 Jun 2016 13:25:05 GMT

Hi,

I think that a combination with Pick, Dimensionality and Dual functions can do it.

Pick(Dimensionality()+1,

Expr0 -> Dual(Num(ExprMonthly,'#.##0')&chr(10)&Num(ExprPercent,'#.##0%')

Expr1 (Your expression for calculate Monthly income)

)

On Presentation, in label for totals -> ='Monthly Income'&chr(10)&'%'

Regards!

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

microwin88x — Tue, 07 Jun 2016 13:43:13 GMT

Hello stalwar1I attach my QVW sample. Hope you can help! Thanks in advance

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

Anonymous — Tue, 07 Jun 2016 13:53:11 GMT

Hi microwin88x,

I have attached you your example with my comment.

Regards

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

sunny_talwar — Tue, 07 Jun 2016 14:02:05 GMT

May be this

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

microwin88x — Tue, 07 Jun 2016 14:02:32 GMT

Hello Manuel, thanks for your answer.

The example is visually ok, but the thing is that I need to export that table to Excel.

And when I do that, I see the following:

Note that the subtotal is concatenated to the total, I would need that information in 2 Rows. For example:

Thank you!!!