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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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..

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