topic Re: Pass in selected field value into sql in QlikView

Pass in selected field value into sql

Tue, 16 Jul 2013 01:53:21 GMT

Hi,

Is it possible to select a field (loaded from inline) from listbox and pass the selection into my SQL script and automatically reload the data?

I know another way is to ask for input when reload the data:

Let vDate = Input('Enter Start Date (MM/DD/YYYY)' , 'Input required');

But this is not the requirement i want.

Thanks

ariel_klien — Tue, 16 Jul 2013 05:24:06 GMT

If I understood you correctly

You can try to use the function GetFieldSelections(),

Put it in a Variable and in the select:

Select *

From Data

Where Data.field = '$(vMyVariable)'

Ariel

Tue, 16 Jul 2013 06:59:49 GMT

Hi,

I tried the GetFieldSelections() function and encountered error when i reload my data.

Select *

From Data

Where Data.field = 'GetFieldSelections([Report Month])'

ariel_klien — Tue, 16 Jul 2013 07:19:22 GMT

Hi,

You need to put the function in a variable and in the select call the variable.

Ariel

Tue, 16 Jul 2013 07:24:23 GMT

ya. i did put the function in a variable. then in my sql, i use '$(vMonth)' but it show me that error.

luciancotea — Tue, 16 Jul 2013 07:48:20 GMT

GetFieldSelections() is an interface function, not script.

1. Add a variable (vSelectedValue) in "Settings" -> "Variable Overview" and assign it the following expression: =GetFieldSelections(myFieldName)

2. In script use: ... WHERE Data.field = '$(vSelectedValue)'

This will work only when you have only one selected value to pass on. If you want multiple values, you need to use a different expression.

Fri, 19 Jul 2013 01:18:22 GMT

Hi,

Yeap, i know GetFieldSelections() is an interface function. However, i have to create a temp variable to assign the value to my variable.

Eg:

vTempSelectedValue = GetFieldSelections()

vSelectedValue = $(vTempSelectedValue)

So in my SQL, it will read vSelectedValue as my actual value instead of showing 'GetFieldSelections()' text.