4 Replies Latest reply: Aug 26, 2016 11:12 AM by Saurabh Bijagare RSS

    How to Write Multiple Conditions In Qlik sense?

    Saurabh Bijagare

      (sum({<DATE_FORMAT= {">=$(=('01-01-2013'))<=$(=('31-12-2013')) "},{<NEW_CUST_FLAG= {"=$(=('N'))"} >} >}NET_SALES_VALUE)-

      -

      sum({<DATE_FORMAT= {">=$(=('01-01-2013'))<=$(=('31-12-2013')) "},{<NEW_CUST_FLAG= {"=$(=('N'))"} >} >} NET_RETURN_VALUE))

       

      Need To Have Only Those Customers Where Cust Flag ='N'