Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I am farely new to QlikView. I am tasked to add a functionality to allow an Admin user to be able to change a certain value at one place and it must filter dynamically throughout the document. Changing the value must be restricted to 2 times a year. How can I go about to achieve this?
Hi Tumelo,
I guess u need to use variables here and use those variables while doing calculation.
eg: Let:Calculates the expression assigned to it and sets the expression result to the variable.
Set: Assigns the value(or expression which is after the equal sign) as it is without compute.
Example:
Set vVar=2+3; //vVar has the expression 2+3 as value we have to compute it using $(vVar) which returns 5
Let vVar=2+3;//vVar has the computed value 5
Hi Tumelo,
I guess u need to use variables here and use those variables while doing calculation.
eg: Let:Calculates the expression assigned to it and sets the expression result to the variable.
Set: Assigns the value(or expression which is after the equal sign) as it is without compute.
Example:
Set vVar=2+3; //vVar has the expression 2+3 as value we have to compute it using $(vVar) which returns 5
Let vVar=2+3;//vVar has the computed value 5
Hi Deepa
Thanks for your answer
One more question though, how would I assign the value that is entered manually by the ADMIN User to a varable?
Hi Tumelo,
You can use input box and after creating variable assign it to input box and use same variable in chart.
Thanks,
Hi
The use of variables alone is not going to help as setting the variable values on the front-end will only be set for that user.
Other options.
Thank you very much guys. Very helpful indeed!