topic Re: Fractile and Count in a dimension in QlikView

Fractile and Count in a dimension

Anonymous — Wed, 05 Sep 2012 08:21:44 GMT

Hello,

I am trying to divide the number of inscriptions in 10 in a dimension to have decile like you can have quartile or mediane in excel.

So I tried this but it seems that you cannot use the fonction "Count" in a Dimension...

=if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.1), 1,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.2), 2,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.3), 3,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.4), 4,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.5), 5,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.6), 6,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.7), 7,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.8), 8,
if(count( @num_insc) <= fractile( TOTAL count( @num_insc), 0.9), 9, 10)))))))))

Re: Fractile and Count in a dimension

danielrozental — Fri, 07 Sep 2012 16:52:25 GMT

Clement, you can use Count but if you're using an expression you need to aggregate it by a dimension.

fractile( TOTAL aggr(count( @num_insc),DIMENSION), 0.9)

Re: Fractile and Count in a dimension

Anonymous — Mon, 10 Sep 2012 09:17:50 GMT

Thank you Daniel.

I would like to use it in a dimension. Is it possible ?

Re: Fractile and Count in a dimension

danielrozental — Mon, 10 Sep 2012 12:50:17 GMT

Wouldn't make much sense, just use a field with values 0.1, 0.2, ... etc.