Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parse data with condition

How do you set a variable from a condition statement. If field A contains the words '# of locations' then set field B to TRUE.

2 Replies
Not applicable
Author

I dont know if I understand well but as can see you can create the 2 variables with the next statement:

Variable1 =if([FIELDNAME]=2009,1,0)

Variable2 =if($(Variable1)=1,'TRUE','FALSE')

You can make a force selection of a field with the information of the variable that you want I meant you can create a button or something to activate a selection depends on the variables that you created.

Hoe it helps.

Not applicable
Author

You should be able to use 'like'.

Variable = If([Fieldname] like '*# of locations*','True','False')

good luck!