topic Re: Passing the variable into SQL script in qlikview in QlikView

Passing the variable into SQL script in qlikview

Mon, 21 Sep 2015 15:49:47 GMT

Hi,

I am new to Qlikview. I created two variables in my qvw file. Here is my variable names

vSelectedValue = GetFieldSelections(fm)

vPassedValue = GetFieldSelections(pm)

When i select the list box i got the values and displayed in text object. My question is i am going to use these variables into my sql script where clause. Here is my sql script.

select *

from mvdate md,

mvpicture mv

where trunc(md.day)=trunc(mv.dates)

and mv.mvpicture='$(fm)';

Please let me know anyone how to pass the variable in my sql script.

Thanks

Venkata

Re: Passing the variable into SQL script in qlikview

Tue, 10 Nov 2015 14:56:56 GMT

Hi Venkat,

Did you get solution for this ? I am looking for similar question. Let me know if you get any possible solution.

Thanks,

Pavan

Re: Passing the variable into SQL script in qlikview

rubenmarin — Tue, 10 Nov 2015 15:35:47 GMT

Hi Pavan, altough i don't think it's a best practice, you can set a trigger to the field (In document properties->triggers), this trigger can assign the value to the variable (action --> external --> set variable)

In variable set the name of the variable and in value set "=FieldName" or "=Concat(FieldName, [separator])" if you want to allow multiple values.

This way the variable will contain the values, the other way the variable still contains the string "GetFieldSelections(fm)"