Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can define in input box
Vikas
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.
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?
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.
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.
thanks but it does not works!!!!
what is KPI?