topic Read List Box value in QlikView

Read List Box value

Sat, 24 May 2014 07:07:50 GMT

Dear QV Expert,

I have a list box with 9 different values. How can i read value from the list box and run my SQL script with selected value and show value in Table box.

Regards,

Masba

Re: Read List Box value

whiteline — Sat, 24 May 2014 14:11:55 GMT

Hi.

You can use either direct discovery or run it with the macro.

But why do you need to run sql script ?

Re: Read List Box value

fkeuroglian — Sat, 24 May 2014 17:55:12 GMT

Using macro could be a posibility

what do you want? insert in sql or create the sentence?

Re: Read List Box value

Sun, 25 May 2014 03:42:01 GMT

Hi,

My requirement is that based on user selected value from list box sql script take it as a parameter. When user click "Reload Button" sql script will be run.

Regards,

Masba

Re: Read List Box value

Sun, 25 May 2014 03:42:29 GMT

Hi,

My requirement is that based on user selected value from list box sql script take it as a parameter. When user click "Reload Button" sql script will be run.

Re: Read List Box value

whiteline — Sun, 25 May 2014 18:45:05 GMT

You can use variable to store the selected value and then use it in the script.

Re: Read List Box value

Mon, 26 May 2014 03:34:06 GMT

Dear Whiteline,

Thanks for your reply. Can u give one example with Code that will be helpful for me as a new qlikview developer.

Regards

Masba

Re: Re: Read List Box value

whiteline — Mon, 26 May 2014 06:00:31 GMT

Hi.

You can use variable to store the statement that you want to use in the script. You have to set it up with a trigger otherwise the entire expression is stored. See the example.

You can consider to use "partial reload" to replace the SQL table only if it's possible instead of realoading full data model.

Look at qlikview help.