Read List Box value

[#1]

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

[whiteline]

Hi.

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

But why do you need to run sql script ?

[fkeuroglian]

Using macro could be a posibility

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

[#4]

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

[#5]

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.

[whiteline]

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

[#7]

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

[whiteline · Accepted solution]

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.