topic Re: Pivot table help in QlikView

Pivot table help

Anonymous — Tue, 08 Dec 2015 21:33:01 GMT

Hello,

I'm trying to figure out how to make a pivot chart with dynamic totals but only for 1 expression. I'm trying to get the months across so that my expressions populate for each month selected. I'm also just trying to get a total for the order count, which is it's own field and not a Count().

Is it possible to have a pivot chart like my example below?

	September		October		Total
Customer	Order Count	Order Average	Order Count	Order Average	Total Order Count
Customer1	3	4	5	4	8
Customer2	5	3	1	3	6
Customer3	10	5	0	5	10

Thank you in advance

Re: Pivot table help

arasantorule — Wed, 09 Dec 2015 02:04:07 GMT

Hi,

Yes. It is possible.

Add your required dimensions and Expressions to the chart.

Drag Month to the row line and Drag columns and field to change your chart as per your requirement.

Thanks.

Re: Pivot table help

tamilarasu — Wed, 09 Dec 2015 03:55:52 GMT

Hi David,

You can enable show partial sum option for the month dimension in presentation tab. Check the attachment for better understanding.

Re: Pivot table help

PrashantSangle — Wed, 09 Dec 2015 04:10:45 GMT

Hi,

If you have two expression and you want Total Sum of only one expression

then using partial sum you can not acheive it.

And I dont think so there is any way to acheive it.

Only If you hardcoded any of the dimension then we can try it.

Regards

Re: Pivot table help

Anonymous — Wed, 09 Dec 2015 14:25:45 GMT

Hi Tamil,

Partial sums would work, however, I have 2 expressions and I only want to show totals for 1 of the expressions

Re: Pivot table help

Anonymous — Wed, 09 Dec 2015 14:27:48 GMT

Hey Max,

Thanks for your response. I was afraid it wouldn't be possible without an overlay or hardcoding but it looks like I may not have a choice.