13 Replies Latest reply: Aug 5, 2017 12:47 PM by Antonio Mancini RSS

    Count function with two conditions QlikSense

    ila ds


      I have a question about the set analysis below:

      I have to calculate the number of Number field which met two conditions:

      - Data avvio UAT pianificata must be between the Start and End of the Month and

      - Data avvio UAT effettiva must be greater than Data Avvio UAT pianificata.


      count({<[Data avvio UAT pianificata]= {'>=$(=AddMonths( MonthStart (Today()),-2))<=$(=AddMonths( MonthEnd (Today()),-2))'},

      [Data avvio UAT effettiva]={'>$([Data avvio UAT pianificata])'}>}Number)


      But it seems to count the number of Number field only taking into account the first condition.


      Which is the error?


      Thanks a lot for your help,