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

    Count function with two conditions QlikSense

    ila ds

      Hello,

      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,

      Ilaria