2 Replies Latest reply: Jun 5, 2018 3:39 PM by Ken Harry RSS

    If/And Function in Qlik

    Ken Harry

      Hello Qlik friends,


      I want to be able to write an if/and statement in a measure.




      if(program name='NA',and(fiscal month='Jan')),50000,

           if(program name ='EMEA',and(fiscal month='Jan',20000 )


      Please let me know if this can be done.


      thank you!