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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selections in document based on variable

Can someone please guide me through this??

I have a Variable in which i will enter a field value. I want that value and the related stuff to get selected just like the way it happens when we simply select any value on the sheet.

I have tried setting the same with Document-> triggers->on event of variable->on inpt/output ->action-.> select the field and the required string

ie:  field is =matid   &  search string is ='m101'   this string is same as the variable value which I entered.

but..its not wrking...can anyone suggest me any corrections or any better solution to this???

3 Replies
Not applicable
Author

the search string shud be '=m101', u need to include the equals sign(=) inside the quotes.

Not applicable
Author

as far as I understandd you should use two actions with a button.

one for selecting the field value and the other to set variable value.

the set variable action will set the value in your variable while the select field action would display the information related..

This will be calculated on runtime any time you click the button the same can be done in script aswell.

Regards.

Not applicable
Author

hi

I used the above ( including = sign  inside). but it still doesnt wrk.though it shows the expression as correct only on writing.. ='m101'

anyhow  i hav got answer in a macro

 

ActiveDocument.Fields("matid").Select("m101") .   this is working.!!

thanx fr the attempt.