Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kharry2415
New Contributor III

If/And Function in Qlik

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

1 Solution

Accepted Solutions
MVP
MVP

Re: If/And Function in Qlik

May be this

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

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

2 Replies
MVP
MVP

Re: If/And Function in Qlik

May be this

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

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

kharry2415
New Contributor III

Re: If/And Function in Qlik

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