topic Count in QlikView

Count

QSense — Fri, 11 May 2012 06:43:08 GMT

Hello

I have a cloumn let's assume B column İt has 0 and 1 values

Iwant to get ratio of 1 over total values

for instance 18 of them 1

total values 21

ratio 18/21

regards

hic — Fri, 11 May 2012 06:59:26 GMT

count(if(B=1,B)) / Count(B)

or, using Set Analysis:

Count({$<B={1}>} B) / Count(B)

HIC

its_anandrjs — Fri, 11 May 2012 07:02:00 GMT

Hi,

Use some thing like this to calculate

=count( if ( Column = '1', Column ) )

=Count(Column)

then you get the ratio 18/21

HTH

Regards,

Anand

Fri, 11 May 2012 07:15:00 GMT

Hi,

Why not use the expression?

= SUM(B) / COUNT(B)

Kind regards,

Matthijs

its_anandrjs — Fri, 11 May 2012 07:18:31 GMT

Hi,

But in case there is any other number other then 1 then condition fails. so i suggest use count if.

Regards

Anand

QSense — Fri, 11 May 2012 07:26:41 GMT

My expression is below

if (sum(MT_AVAILABILITY_ACT)>0,'1') it means it is the name of column

When I try it it gives 0

QSense — Fri, 11 May 2012 08:22:25 GMT

=count(if(MT_AVAILABILITY_ACT>0,MT_AVAILABILITY_ACT))/(count (DISTINCT ID_SEGMENT_CLASS))