topic Re: Expression against Partial Sum in QlikView

Expression against Partial Sum

Sat, 02 Apr 2016 18:33:35 GMT

Hi all, just hoping someone can suggest if there is a way of displaying an expression referencing a Partial Sum row but showing the expression on the same row, in my very basic example I want to show the percentage of Sum of Section B divided by the number of say closed Calls (Section A) but I want it to show on the same row as the Partial Sum Total of Section B.

Also this has to be in a Pivot table as users want to see Company across the top along with potentially other dimensions like Month etc..., e,g.

Many thanks!

Re: Expression against Partial Sum

sunny_talwar — Sat, 02 Apr 2016 19:16:31 GMT

This may be

=If(Section = 'B' and Dimensionality() = 1, Num(Sum(Measure)/Only({<Description = {'Total Complaints Closed'}>} TOTAL <Company> Measure), '##.##%'), Sum(Measure))

Re: Expression against Partial Sum

Sat, 02 Apr 2016 20:56:41 GMT

That's a nice solution, works perfectly, many thanks!!!