topic Set variable value. in QlikView

Set variable value.

Fri, 25 Nov 2011 11:49:19 GMT

I have set the variable value in query editor.

SET VarValue = 34;

and also set this value in the sql where condition.

select * from

[AdventureWorksDW]

[DimCurrency]

where CurrencyyKey = $(VarValue);

in the designer i used input text box to change the variable value to populate table box at the run time but its not changing. may i know where i am doing wrong or i am missing some steps?

Set variable value.

Fri, 25 Nov 2011 12:44:09 GMT

You have to remove the SET VarValue=32. Every time you run the script it Will be set to 32 again, regardless of whagt you do in your GUI- input.

Set variable value.

Anonymous — Fri, 25 Nov 2011 13:22:53 GMT

Hi javedkha,

Try this is your query editor

set varValue = $(var1)

Here the "var1" is an another variable . you can create this variable in your presentation file (Settings-->Variable Overviews)

then create one input box with the variable of "var1" ,enter your value and reload it...

Set variable value.

Fri, 25 Nov 2011 13:47:07 GMT

Like vegar said, you only need to delete the line "SET VarValue = 34;" of your script.

The variable already exists, and every time that you run your script the value is being setted to 34...

Good luck

Bruno

Set variable value.

Anonymous — Mon, 28 Nov 2011 18:55:10 GMT

or try:

if IsNull(varValue) then; SET varValue = '32'; end if;