Can we pass the value at Runtime in QlikView using SET and LET variables and also is there any way to define then tell me please!!!!!!!!!!!!!

[#1]

Can we pass the value at Runtime in QlikView using SET and LET variables and also is there any way to define then tell me please!!!!!!!!!!!!!

[Anonymous]

I am not sure if i understand your questions.

If you are asking can you define variable during the reload of document then yes, you can. as you have mentioned, use the SET or LET statements and define the variable and use it where ever required.

If you are asking can you create a variable on the dashboard while accessing on the accesspoint. I dont think so. You can have the variables created in the script and change them on by using a button and an action to the required behaviour you are looking for.

Hope that helps.

Aadil

[vikasmahajan]

you can define in input box

Vikas

[vinay_hg]

hmmm.. create a input box, assign the value entered in input box to a variable, then use the variable for the expression calculation. but u should use the triggers for the same to make variable values activate in the calculation. may be in the chart or in buttton.

[#5]

In C.C++ language where we can send the inputs from key board at runtime like in commmand promt we enter the we pass the values to thee variables........

So there is any way to pass the values in qlik view after declaring the varibles?

[jagan]

Hi,

Try like this using Load statement

Temp:

LOAD

Input('Enter value', 'Input box') AS InputValue

AutoGenerate 1;

LET vInputValue = Peek('InputValue');

DROP TABLE Temp;

Regards,

Jagan.

[vardhancse]

hi,

Variables can be loaded in run time through LET and SET.

And we are loading variables using excel sheet, as we have more number of graphs and more KPI's.

For every KPI we have created one variable in excel sheet and in chart expressions we are using variable instead of direct expressions.

so while loading the dashboard it will fetch the variable value and will use in the chart.

[jagan]

Hi,

Check this thread

Getting Input while reloading in Qlikview

Hope it helps you.

Regards,

Jagan.

[#9]

thanks but it does not works!!!!

[#10]

what is KPI?