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.
May be this
If(program name = 'NA' and fiscal month = 'Jan', 50000,
If(program name = 'EMEA' and fiscal month = 'Jan', 20000))
It works, thank you so much!!! Making a co-op look really good
Retrieving data ...