Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Could you post a small sample QVW that demonstrates your issue?
I have attached a quick sample to my original response.
Thanks!
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
Thank you.