Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pyrodirk
New Contributor

Count based on a formular - not on a field

Hi,

please have a look at the following table:

qlikviewtable.bmp

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

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

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

Try

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

3 Replies
Not applicable

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

Have you tried something like this in your text box?

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

pyrodirk
New Contributor

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

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

MVP
MVP

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

Try

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

Community Browser