topic Re: Count Customesr only when ... in QlikView

Count Customesr only when ...

pyrodirk — Tue, 18 Sep 2012 14:17:31 GMT

i can reduce my problem to a table with three fields , Customernumber, ordernumber, total_sum.

Now i want to know in a text field, how many customers (count) i have, who's total amount is greater than 1500.

I tryied something like this

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

but the result is still 0. What i am doing wrong here.

Regards

Dirk

Re: Count Customesr only when ...

Tue, 18 Sep 2012 14:19:30 GMT

Try:

=Count({$<TOTAL_SUM={'>1500'}>} DISTINCT CUSTOMER_NR)

Check that all your fields match exactly.

Re: Count Customesr only when ...

pyrodirk — Tue, 18 Sep 2012 14:23:22 GMT

Thanks for the very fast reply, but still the result is 0.

Re: Count Customesr only when ...

MayilVahanan — Tue, 18 Sep 2012 14:23:47 GMT

Try like this

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

If(Total_Sum > 1500, count(Distinct Customer_Nr)

Hope that helps

Re: Count Customesr only when ...

pyrodirk — Tue, 18 Sep 2012 14:31:34 GMT

No , it is still not working....

Re: Count Customesr only when ...

MayilVahanan — Tue, 18 Sep 2012 14:32:52 GMT

Can you provide a sample file?

Re: Count Customesr only when ...

pyrodirk — Wed, 19 Sep 2012 09:46:59 GMT

Hi ,

as i build the example application i found the error. The reason why it was not woring was, that i format the TOTLA_SUM as Money so the part of the look like =Count({$<TOTAL_SUM={'>1500,00 €'}>} DISTINCT CUSTOMER_NR). So thanks again for the help.

Dirk