topic not very complex calculation in QlikView

not very complex calculation

Wed, 26 Jan 2011 10:51:34 GMT

Hi!

It's realy not very complex calculation, but it make me stuck.

My problem:

i need to calculate something like this

Data:


LOAD * INLINE [
 man, value
 man01, 3
 man02, 4
 man03, 2
 man01, 3
 man01, 4
 man03, 2
 man02, 5
 man02, 3
 man02, 4
 man02, 5
];

I need to know how many men have sum(value) > 11 (call men, who have sum(value) > 11, like cool_men),

and then count(distinct cool_men)/ count(distinct man)

It mast be gauge chart.

Regards,

Igor

matt_crowther — Wed, 26 Jan 2011 11:10:12 GMT

Igor,

Attached file should do it using the aggr() function.

The key element is:

=count(if(aggr(sum(value),man)>11,man))

And in a gauge:

Hope that helps,

Matt - Visual Analytics Ltd

Wed, 26 Jan 2011 11:54:48 GMT

Thank! i never use aggr, that was my fail.)

Thank one more time!!!