topic How to Count 3 conditional counts in QlikView

How to Count 3 conditional counts

Tue, 10 May 2011 08:59:56 GMT

I got a expression like this

COUNT(IF(categori='x' OR categori='y',item)) and want to add an extra condition.

Somthing like this

COUNT(IF(YEAR='2011' AND categori='x' OR categori='y',item))
but this expression does´nt work right - I do not get the right result

Tue, 10 May 2011 09:04:45 GMT

COUNT(IF(YEAR='2011' AND categori='x' AND categori='y',item))

Tue, 10 May 2011 09:08:45 GMT

hi ,

if category have one value ( X or Y)

COUNT(IF(YEAR='2011' AND (categori='x' OR categori='y'),item))

Tue, 10 May 2011 09:49:28 GMT

Hello Did you try this Set Analysis:

COUNT({$<YEAR = '2011', Categori = {'x', 'y'}>} item)

Can you please try and let me know.

Thanks

Tue, 10 May 2011 09:50:02 GMT

Hi,

Try Count ( if ( year = '2011' , if ( catagory = 'X' or catagory = 'Y' , item ) ) )

Regards,

Shubhu

Tue, 10 May 2011 10:31:56 GMT

MUCHO

the expression gives med a 0 - and that is wrong

Tue, 10 May 2011 10:33:10 GMT

shubhu - Your expression works for me