topic Re: Any help on set analysis with Avg and Total in QlikView

Any help on set analysis with Avg and Total

Wed, 08 Apr 2015 08:34:50 GMT

I have a Dimension with Target % which has calculated Averages.While Using in Measure with set Analysis as Avg(Target %)giving Averages and need to have a Total of sum.

Set analysis i used =Avg([Target %])

Items	Target %
A	-10.0%
C	5.0%
D	75.0%
UnScored	5.0%
Total	20.0%

Above Target % Measure is giving individual values as Average but Total is also taking Avg but expected is Total need 28.21%

Re: Any help on set analysis with Avg and Total

kkkumar82 — Wed, 08 Apr 2015 09:05:16 GMT

can u be clear on ur requirement, 28.21% is no where matching ur data given.

Re: Any help on set analysis with Avg and Total

matthewjbryant — Wed, 08 Apr 2015 09:22:22 GMT

I agree with kiran ch; we need more information to understand how you are arriving at 28.21%.

Having said that, on the Expressions tab there is a section for Total Mode. Play around with Expression Total and the drop down menu.