topic Re: on List box selection set variable value in QlikView

on List box selection set variable value

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

I want to set variable value on list box selection. In my listbox i have 2 values Monthly and Yearly.

I want to set my variable with list box selected values. I want to use variable value with barchart monthly and yearly data. I have tried Document properties with Trigger option

onAnySelect (option) to set fieldname with variable

and i have tried

onselect option

and variable oninput option

but no one is working for me.

kindly guide how can i achieve this.

Thanks

Re: on List box selection set variable value

Qlik1_User1 — Mon, 02 Mar 2020 14:14:08 GMT

Try this..

Create a variable with

vVariable = GetFieldSelections(Field name)

Re: on List box selection set variable value

syedzee — Mon, 02 Mar 2020 14:36:04 GMT

Hi,

Please guide me where i have to create and mentioned scripts. kindly guide me step wise.

Thanks

Re: on List box selection set variable value

Qlik1_User1 — Mon, 02 Mar 2020 14:46:11 GMT

Step1: Create a variable at front end.. IF you are using Qlikview go to setting-->variable overview-->create variable

If using QlikSense -->go to edit mode on sheet-->on left bottom-->variables-->create variable

Step2: Use that variable like $(vVaraible ) in bar chart

Re: on List box selection set variable value

syedzee — Tue, 03 Mar 2020 05:33:40 GMT

I have tried your solution but its not working for me.

I have created variable with

vDate=GetFieldSelections(Desc)

and used it for display value in text box on selection of list option but its only showing above string instead of values.

snapshot is attached for your review.

Re: on List box selection set variable value

Qlik1_User1 — Tue, 03 Mar 2020 06:17:07 GMT

Use =$(vDate) in Textbox ..you have used input box .

Its working for me.

Re: on List box selection set variable value

syedzee — Tue, 03 Mar 2020 08:17:57 GMT

Thanks now its working i used text object.