Partial Sums and Expression Totals Disabled on Pivot Table

[#1]

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

[swuehl]

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

[#3]

I have attached a quick sample to my original response.

Thanks!

[stevedark · Accepted solution]

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/

[#5]

Thank you.