If/And Function in Qlik

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be this

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

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

[Anonymous]

It works, thank you so much!!! Making a co-op look really good