Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi,

Try like below,

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

View solution in original post

8 Replies
Not applicable
Author

Hi,

Try like below,

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

View solution in original post

pokassov
Specialist
Specialist

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

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

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

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

qlikmsg4u
Specialist
Specialist

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

Not applicable
Author

work great, thanks everybody

Not applicable
Author

works Great thanx a lot

Not applicable
Author

Hi Teneman,

Try like this:

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



Ramya.