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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Select In Field

Hello,

I'm Trying to use Select In Field action -

i have 4 different fields with the value "1"

and variable vMonth (input field - 6,12,18..) .

what I'm trying to do with the action is :

Field:

if(vMonth=6, Field1,

if(vMonth=12, Field2 and so on))

Search String:

1

but its not working..

Labels (1)
13 Replies
sunny_talwar
MVP
MVP

I added 4 select in field triggers instead of 1.

Field

Field1

Search String

If(vMonth = 6, 1)

Field

Field2

Search String

If(vMonth = 12, 1)


Field

Field3

Search String

If(vMonth = 18, 1)


Field

Field4

Search String

If(vMonth = 24, 1)

Anonymous
Not applicable
Author

well i cannot see the triggers 😕

where did you add them?

Anonymous
Not applicable
Author

In the Document properties- Triggers- Variables

sunny_talwar
MVP
MVP

Yup... as Shiva pointed out... it is in Document Properties... I have used the trigger for vMonth... So based on the value (6, 12, 18, 24) entered, one of the fields will select 1