Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
napac1458
Creator II
Creator II

Pivot table help

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?

SeptemberOctober

Total

CustomerOrder CountOrder AverageOrder CountOrder AverageTotal Order Count
Customer134548
Customer253136
Customer31050510

Thank you in advance

5 Replies
arasantorule
Creator III
Creator III

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.

tamilarasu
Champion
Champion

Hi David,

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

Capture.PNG

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
napac1458
Creator II
Creator II
Author

Hi Tamil,

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

napac1458
Creator II
Creator II
Author

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.