Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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.

Labels (1)
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!