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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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..

13 Replies
sunny_talwar

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

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