topic Re: SUM 2 conditional counts in QlikView

SUM 2 conditional counts

Mon, 09 May 2011 08:40:34 GMT

I´m trying to sum 2 counts like this, but i get no result

SUM(Count(if(category='x', item))+ (Count(if(category='y', item))

brenner_martina — Mon, 09 May 2011 08:57:06 GMT

Hi,

you have to use the AGGR function, if you use two aggregation functions like this:

Sum(Aggr(Count(if(category='x', item)),Dimension))+ Sum(Aggr(Count(if(category='y', item)),Dimension))

Sum(Aggr(Count(if(category='x' or category='y', item)),Dimension

with more performance I would recommend this:

Sum(Aggr(Sum(if(category='x' or category='y', 1,0)),Dimension))

Dimension can be more than one: Dim1,Dim2,Dim3,...

Mon, 09 May 2011 09:00:34 GMT

Hi Polschou,

why you use sum?

you can get the result direct with

Count(if(category='x' or category='y', item))

and try to use set anylasis as following

count({<category={'x','y'}>} item)

hope this help you

Mon, 09 May 2011 09:02:33 GMT

Hi Martina

I tried somthing else and it seems to work for me - I use this to add the 2 conditions

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

Tue, 10 May 2011 08:56:36 GMT

Hi Mohammed

If I want to add another condition like this

COUNT(IF(categori='x' OR categori='y' AND YEAR='2011',item)) - but this gives a wrong result - I cant attach a

QW file

Tue, 10 May 2011 09:05:34 GMT

i think it should be like the following:

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

count({<categori={'x','y'},YEAR='2011'>} item)

the diffrent is ( ) between Category and Year

hope this help you.