Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pyrodirk
New Contributor

Count Customesr only when ...

Hi

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

1 Solution

Accepted Solutions
Not applicable

Re: Count Customesr only when ...

Try:

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

Check that all your fields match exactly.

6 Replies
Not applicable

Re: Count Customesr only when ...

Try:

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

Check that all your fields match exactly.

pyrodirk
New Contributor

Re: Count Customesr only when ...

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

Re: Count Customesr only when ...

Hi

Try like this

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

or

If(Total_Sum > 1500, count(Distinct Customer_Nr)

Hope that helps

pyrodirk
New Contributor

Re: Count Customesr only when ...

No , it is still not working....

Re: Count Customesr only when ...

Hi

Can you provide a sample file?

pyrodirk
New Contributor

Re: Count Customesr only when ...

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



Community Browser