topic Re: selections in document based on variable in QlikView

selections in document based on variable

Thu, 10 Jan 2013 05:01:51 GMT

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???

Re: selections in document based on variable

Thu, 10 Jan 2013 05:22:17 GMT

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

Re: selections in document based on variable

Thu, 10 Jan 2013 05:28:15 GMT

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.

Re: selections in document based on variable

Thu, 10 Jan 2013 06:52:16 GMT

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.