topic Re: Assigning Variable to Listbox!! in QlikView

Assigning Variable to Listbox!!

Thu, 10 Oct 2013 16:58:26 GMT

I just want to assign a variable to the list box which will trigger the event based on my selection in the list box.

Suppose I have a list box 'X' with different fields as "A","B","C" and want to create a chart which shows the %sales of A,B,C on selecting the respective field from the list box.

How can i assign the Sales% variable to my list box which will show graph as per my selection assuming my variable name is vsales.

Thanks

Re: Assigning Variable to Listbox!!

Clever_Anjos — Thu, 10 Oct 2013 17:08:18 GMT

Right-Click "New Sheet Object" / ListBox

At "field" choose "Expression" (is the last option)

Include your var name there

Re: Assigning Variable to Listbox!!

rustyfishbones — Thu, 10 Oct 2013 17:13:32 GMT

why can't you create a button to this?

add an action to the button set variable.

Re: Assigning Variable to Listbox!!

rustyfishbones — Thu, 10 Oct 2013 17:44:17 GMT

Is this the type of Functionality you are talking about

See Attached

Re: Assigning Variable to Listbox!!

Thu, 10 Oct 2013 18:21:51 GMT

Hi Alan ,

Thanks for your reply but couln't able to open the qvw file as i am working on personal edition.

I just want to show graph by using variable in list box with respect to my selection .

Thanks,

Vaneet

Re: Assigning Variable to Listbox!!

Thu, 10 Oct 2013 23:51:44 GMT

Vaneet1313

try this,

go to Document Property, Triggers tab, browse to the desired field and apply an action that change the value of the variable when making a selection in this field.

Re: Assigning Variable to Listbox!!

Fri, 11 Oct 2013 05:21:39 GMT

Hi,

Go to settings->variable overview->create a variable->and add definition as =GetFieldSelections(FieldName)

Now you can get the selected value in the variable for particular field

Re: Assigning Variable to Listbox!!

Fri, 11 Oct 2013 20:26:32 GMT

Thanks Claudio.