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.

       

      Example:

       

      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!

      Ken