Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
If(program name = 'NA' and fiscal month = 'Jan', 50000,
If(program name = 'EMEA' and fiscal month = 'Jan', 20000))
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