topic Partial Sums and Expression Totals Disabled on Pivot Table in QlikView

Partial Sums and Expression Totals Disabled on Pivot Table

Tue, 16 Jul 2013 20:05:28 GMT

Hello,

I am trying to display expression totals at the bottom of a pivot table. Currently, I am using a valuelist, and the expression totals under the Expressions tab are disabled. I tried using the partial sums under the valuelist dimension, but nothing happened. Any input would be greatly appreciated.

Thanks,

Emily

Re: Partial Sums and Expression Totals Disabled on Pivot Table

swuehl — Tue, 16 Jul 2013 20:46:49 GMT

Could you post a small sample QVW that demonstrates your issue?

Re: Partial Sums and Expression Totals Disabled on Pivot Table

Tue, 16 Jul 2013 21:19:49 GMT

I have attached a quick sample to my original response.

Thanks!

Re: Partial Sums and Expression Totals Disabled on Pivot Table

stevedark — Tue, 16 Jul 2013 22:44:37 GMT

Hi Emily,

You need to sum up the Sales values, as QlikView can not presently show totals as these will be many distinct values.

The expression therefore needs to be:

if(valuelist('Weekly Sales', 'Monthly Sales', 'Annual Sales') = 'Weekly Sales',

sum(Sales)/52,

if(valuelist('Weekly Sales', 'Monthly Sales', 'Annual Sales') = 'Monthly Sales',

sum(Sales)/12,

if(valuelist('Weekly Sales', 'Monthly Sales', 'Annual Sales') = 'Annual Sales',

sum(Sales))))

Hope that helps!

Cheers,
Steve

http://www.quickintelligence.co.uk/

Re: Partial Sums and Expression Totals Disabled on Pivot Table

Wed, 17 Jul 2013 16:29:52 GMT

Thank you.