if condition

[#1]

Hello community ,

i have a lil probleme with if,

i have a field that can take two values 'Pose' and 'Depose' and i want to have with my if expression '1' for 'Pose' and -1 for 'Depose'

my solution was : if([Pose / Dépose]={"Pose"},1,-1)

but that doesent work, i miss something?

Thanx

[#2 · Accepted solution]

Hi,

Try like below,

if([Pose / Dépose]='Pose',1,-1)

[pokassov]

Hello!

if([Pose / Dépose]='Pose',1,-1)

[PrashantSangle]

Hi,

try

if(wildmatch(fieldname,'Pose'),1,if(wildmatch(fieldname,'Depose'),-1))

or

if(wildmatch(fieldname,'Pose'),1,-1)

Regrds

[Anonymous]

I assume the field is called "Pose / Dépose"... Try this:

=if([Pose / Dépose]= 'Pose', 1,-1)

[qlikmsg4u]

if([field] = 'Pose',1,-1)

[#7]

work great, thanks everybody

[#8]

works Great thanx a lot

[#9]

Hi Teneman,

Try like this:

if([Pose / Dépose]={'Pose}',1,-1)

Ramya.