topic if condition in QlikView

if condition

Mon, 13 Jul 2015 09:40:26 GMT

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

Mon, 13 Jul 2015 09:44:01 GMT

Hi,

Try like below,

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

pokassov — Mon, 13 Jul 2015 09:44:36 GMT

Hello!

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

PrashantSangle — Mon, 13 Jul 2015 09:45:02 GMT

Hi,

try

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

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

Regrds

Anonymous — Mon, 13 Jul 2015 09:45:15 GMT

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

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

qlikmsg4u — Mon, 13 Jul 2015 09:45:30 GMT

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

Mon, 13 Jul 2015 09:49:06 GMT

work great, thanks everybody

Mon, 13 Jul 2015 09:50:10 GMT

works Great thanx a lot

Mon, 13 Jul 2015 10:16:23 GMT

Hi Teneman,

Try like this:

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

Ramya.