topic Re: Count based on a formular - not on a field in QlikView

Count based on a formular - not on a field

pyrodirk — Wed, 19 Sep 2012 14:09:17 GMT

Hi,

please have a look at the following table:

In a textfield i want to count the number of customers who have an OVERALL > 120,00 Euro ( must be 4 - 1 ,2,3,4) . The problem here ist that OVERALL is a formular definded as Sum(TOTAL <CUSTOMER_NR> TOTAL_SUM ) not a field . How to do that in this case ?

Regards

Dirk

Re: Count based on a formular - not on a field

Wed, 19 Sep 2012 14:25:33 GMT

Have you tried something like this in your text box?

=if(Sum(TOTAL <CUSTOMER_NR> TOTAL_SUM )>110,Count(DISTINCT CUSTOMER_NR))

Re: Count based on a formular - not on a field

pyrodirk — Wed, 19 Sep 2012 14:34:51 GMT

Yes , of course - you can put it in the last text Field on my demo application. I get wrong results (6) or a - whe i try to adjust the 110 to somethig like "110,00 €" , because that was my previous problem when counting against a value.

Dirk

Re: Count based on a formular - not on a field

swuehl — Wed, 19 Sep 2012 14:53:14 GMT

Try

=Count( {$< CUSTOMER_NR={"=Sum(TOTAL_SUM)>110"} >} DISTINCT CUSTOMER_NR )