topic Re: set two variables from one list box? in QlikView

set two variables from one list box?

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

i looked at this Capture ListBox Selections in separate variables | Qlik Community but how do i set two variables - time_period_1 and time_period_2, from the same drop down list box? i want the use to pick one, and set that to time_period_1 and then pick another and set to time_period_2, but within the same drop down. can this be done? thanks

becki kain

Re: set two variables from one list box?

vishsaggi — Wed, 04 Oct 2017 19:57:06 GMT

Can you share an example of what selections you make?

use like

time_period_1 variable have the expr like

= Subfield(GetFieldSelections(fieldname, ','), ',', 1)

time_period_2 variable have the expr like

= Subfield(GetFieldSelections(fieldname, ','), ',', 2)

Re: set two variables from one list box?

ravikumar_iyana — Thu, 05 Oct 2017 00:53:08 GMT

Hi,

In List Boxes have

Properties-> Constrains-> Listed Values-> Only Selected Values Display-> There you can mention

Then it will be displayed

Re: set two variables from one list box?

becki_kain — Thu, 05 Oct 2017 14:23:00 GMT

I have a list box with a bunch of values in it. I want to set a variable of time_period1 to the first thing the user clicks on, in this list box, and a variable of time_period 2 of the second thing. where, in that example, are you setting the variables? thanks

Re: set two variables from one list box?

vishsaggi — Thu, 05 Oct 2017 14:48:45 GMT

Click Ctrl+Alt+V you can see a variable window there add these expression for two variables.

Re: set two variables from one list box?

becki_kain — Thu, 05 Oct 2017 14:53:11 GMT

that was what I was missing - you have to add the variables first. I will try it with one input, then get crazy and try with two!

(yes, my first workflow in qlik!)

Re: set two variables from one list box?

vishsaggi — Thu, 05 Oct 2017 15:03:49 GMT

Sure. Else share your app which you are working on i will try to create and explain you accordingly.

Re: set two variables from one list box?

becki_kain — Thu, 05 Oct 2017 15:29:11 GMT

thank you! works perfectly! (yes, my coworker warned me qlik has a huge learning curve!)