Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

if condition

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

1 Solution

Accepted Solutions
Not applicable

Re: if condition

Hi,

Try like below,

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

View solution in original post

8 Replies
Not applicable

Re: if condition

Hi,

Try like below,

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

View solution in original post

pokassov
Valued Contributor

Re: if condition

Hello!

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

Re: if condition

Hi,

try

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

or

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

Regrds

Great dreamer's dreams never fulfilled, they are always transcended.
marcarreras
Valued Contributor

Re: if condition

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

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

qlikmsg4u
Valued Contributor

Re: if condition

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

Not applicable

Re: if condition

work great, thanks everybody

Not applicable

Re: if condition

works Great thanx a lot

Not applicable

Re: if condition

Hi Teneman,

Try like this:

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



Ramya.