Nested Set Analysis??

Anonymous — Wed, 18 Sep 2013 12:31:04 GMT

Hello

Attached is an issue i am trying to resolve and was hoping somebody may have an answer to.

I have two dimensions 'Team' and 'Month' and the following expression;

=IF(SUM({<Month={3}>}Sales)/SUM({<Month={3}>}Calls)<0.3,NUM(SUM(Sales)/SUM(Calls),'#,###%'))

What i want is if the percentage for 'Month 3' for any 'Team' is below 30% then return the results for those teams for each 'Month'.

i.e. 'Teams 101 and 103' have a % below 30% in 'Month 3' therefore i want to display 'Teams 101 and 103's' results for 'Months 1, 2 and 3' and not display 'Team 102' at all.

Many thanks in advance.

Re: Nested Set Analysis??

Gysbert_Wassenaar — Wed, 18 Sep 2013 12:54:43 GMT

See attached example.

Re: Nested Set Analysis??

Anonymous — Wed, 18 Sep 2013 13:17:12 GMT

Thank you G Wassenaar, i didn't even think of the AGGR function!!!!

topic Re: Nested Set Analysis?? in QlikView

Nested Set Analysis??

Re: Nested Set Analysis??

Re: Nested Set Analysis??