6 Replies Latest reply: Mar 26, 2018 3:43 AM by Gysbert Wassenaar RSS

    How to use multiple values in if else statement with same dimension in qlik sense

    Shahzad Ahsan

      Hi Everyone

      This is SQL statement

       

      Count(DISTINCT REQ_NUMBER) Where (REQ_CREATION_DATE >=sysdate-7 or PO_RECEIVE_DATE >=sysdate-7)

      and REQ_STATUS  NOT IN ('APPROVED','CANCELLED')

       

      I want to implement this as an expression. I have done something like this

       

      Count(distinct if((REQ_CREATION_DATE>=Today()-7 or PO_RECEIVE_DATE >=Today()-7)  and REQ_STATUS<>'APPROVED' , REQ_NUMBER))

       

      How to give multiple values Like APPROVED and CANCELLED at the same time.