topic Re: How to update query based upon user's selection in inputbox? in QlikView

How to update query based upon user's selection in inputbox?

Sun, 12 Jan 2014 19:15:51 GMT

Hi experts,

I used this post to to update the query based upon user's selection (or entry) in Inputbox, This is what I did.

1. Create a variable vSelectedValue in Settings-Variable overview with a value 2013.

2. In Inputbox property - chose vSelectedValue as ONLY displayed variables.

3. In SQL I used WHERE year(a.DischargeDTS)='$(vSelectedValue)'

However, when I selected (or enter) different values (2011,2012). The data is not updated. I do not what I have missed.

Thanks

Longmatch

Re: How to update query based upon user's selection in inputbox?

whiteline — Sun, 12 Jan 2014 19:34:10 GMT

Hi.

If you manually substitute into the WHERE statement the values that you've entered, I think you'll see the problem with syntax.

Re: Re: How to update query based upon user's selection in inputbox?

Mon, 13 Jan 2014 21:05:10 GMT

Hi Whiteline,

I cannot find what is wrong with my code. Please see my example in the attachment. Thanks

Longmatch

Re: How to update query based upon user's selection in inputbox?

maxgro — Mon, 13 Jan 2014 23:39:44 GMT

in my environment with a SqlServer db it works when I reload

I only changed

='$(vSelectedValue)'

with

=$(vSelectedValue)

SQL

SELECT TOP 10

[dat_data]

FROM [sisim_stat].[dbo].[d003_date]

where year(dat_data) >= $(vSelectedValue)

;

Regards

Re: How to update query based upon user's selection in inputbox?

Tue, 14 Jan 2014 15:30:02 GMT

Hi Massimo,

I made changes based upon your suggestions, but nothing happened when I either selected a value from Inputbox or entered a value into Inputbox. It looks like the value is linked back to SQL query. Inputbox links to variable (vSelectedValue) which was defined in Variable window and was used in SQL. I would like to know how to pass the selected value in Inputbox back to query? Is trigger required? Thanks

Longmatch

Re: How to update query based upon user's selection in inputbox?

Tue, 14 Jan 2014 17:19:02 GMT

You might find this interesting. (Dynamic Update)

How to use Dynamic update action in QV 11

Thanks,

Angad

Re: How to update query based upon user's selection in inputbox?

whiteline — Tue, 14 Jan 2014 18:26:58 GMT

The script is executed only during document reload.

No matter what you've entered in the inputbox or variable, to get changes you need reload the document with a user action or trigger/button.

There are also some special possibilities as Dynamic update and so on, but this could not be the case to use them.

Why do you want to use SQL query? You can use common approach, load all years and then let the user use the associative logic of QlikView.