topic Count doesn´t work with expression in QlikView

Count doesn´t work with expression

Fri, 29 Jun 2012 12:32:06 GMT

Hi,

I´m trying to do a count of an expression. The count and expression look like this:

Count

(
(if(Minimum='NA' or
Sum(Maximum)-
Avg(TotalSample)<=
Avg(TotalSample)-
Sum(Minimum),
Sum(Maximum)-
Avg(TotalSample),
Avg(TotalSample)-
Sum(Minimum))
/3/Stdev(TotalSample

))>=(133/100))

Does anybody know how I´m supposed to do this count in order for it to pase and work!?

Thank!

Marita

Re: Count doesn´t work with expression

swuehl — Fri, 29 Jun 2012 13:16:38 GMT

You can't embed an aggregation function into another (sum or avg into count), you need to use advanced aggregation to do something like this (check the aggr() function for more details).

The exact syntax is depending on the dimensions you want to use for the advanced aggregations, but it will look maybe like

Count

(

aggr

(

if(Minimum='NA' or (Sum(Maximum)-Avg(TotalSample) )<= (Avg(TotalSample)-Sum(Minimum)) ,
Sum(Maximum)-Avg(TotalSample),
Avg(TotalSample)-Sum(Minimum) )
/3/Stdev(TotalSample)

, AGGRDIM1, AGGRDIM2

) )