topic Re: Select a listbox value based on a variable's value in QlikView

Select a listbox value based on a variable's value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

First things first, I am a huge fan of the the Qlik community and have learnt to solve a lot more problems and understood concepts more than I have from any other source on Qlikview .Kudos to you guys who help out and I hope to get enough acquainted to pitch in my 2 cents sometime soon.

I have a question on how to choose a value in a list box based on a variable's value.

I.e I have a list box with values a,b,c and I have a variable var=a. I would like to set the list box to select to 'a'

Page 1 has a command button which will set var to a and page 2 has the list box.

I have tried a couple of combinations to achieve this without success. Any or help would be much appreciated.

Thank you

Re: Select a listbox value based on a variable's value

swuehl — Sun, 20 Nov 2016 22:17:17 GMT

Maybe use a trigger (e.g. a button trigger or a OnInput/OnChange variable trigger) with a Selection - Select in field action.

Use the list box field to select in an as search string:

=var

Re: Select a listbox value based on a variable's value

Anonymous — Sun, 20 Nov 2016 22:36:01 GMT

Dear Mr, Wuhl,

Thank you for your input.

I tried both OnInput and Onchange variable trigger. No luck. Could I try a different option.

Thanks

Re: Select a listbox value based on a variable's value

swuehl — Mon, 21 Nov 2016 00:01:12 GMT

OnInput variable trigger with a Select in field action worked for me.

Alternatively, try a button trigger.

See attached.

Re: Select a listbox value based on a variable's value

trdandamudi — Mon, 21 Nov 2016 00:24:44 GMT

Please see the attached and hope this is what you are looking for:

Re: Select a listbox value based on a variable's value

Anonymous — Mon, 21 Nov 2016 01:45:56 GMT

Perfect ! This works Mr.Wuhl. Thank you.

Just that I have a hierarchy within my list box and thus when I have a 'Activate Sheet' trigger in my hierarchy to navigate to another sheet it doesn't seem to work.

I had 'Always one selected' on the list box properties before in which case 'Select in field' Action doesn't seem to work. Is it possible to have a work around on this one ?

Please find the sample attached for the same.

Thanks

Best,

Harini

Re: Select a listbox value based on a variable's value

johnca — Mon, 21 Nov 2016 01:57:43 GMT

Perhaps this one?

Input your value for the variable, var, and click the button.

HTH,

John

Re: Select a listbox value based on a variable's value

Anonymous — Mon, 21 Nov 2016 03:02:30 GMT

Thank you for your response Mr. Dandamudi. This solution seems to work as well. But I am hoping to set the variable from within the command which I was able to succeed in doing.

As an extension, I am trying to work to resolve the same selection from within a list box.

Please find the attachment where I have a hierarchy within a list box and I'm trying to select each value from within the hierarchy which should direct me to a page of its own. Right now this doesn't seem to work. Please share your thoughts on the same.

Thanks.

Re: Select a listbox value based on a variable's value

trdandamudi — Mon, 21 Nov 2016 09:26:15 GMT

Please see the attached file and hope this is what you are looking for ....

For example, If you select 'A' in the hierarchy it will go to the Sheet1. If you select 'B' in the hierarchy it will go to the Sheet2 and so on ... I used the Field Event Triggers to accomplish this. Hope this helps...

Re: Select a listbox value based on a variable's value

sarasunagaram — Mon, 21 Nov 2016 11:10:01 GMT

Hi,

Can you check attached qvw file.

I hope it will be helpful for you.

Thanks,

Muni