3 Replies Latest reply: Sep 19, 2012 10:53 AM by Stefan Wühl RSS

    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