Dynamic Fuctionality

[#1]

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?

[deepakqlikview_123 · Accepted solution]

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

[#3]

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?

[deepakqlikview_123]

Hi Tumelo,

You can use input box and after creating variable assign it to input box and use same variable in chart.

Thanks,

[DavidFoster1]

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.

1. Same 'variables' approach, but set the variable in the development copy of the app and then redeploy to publish the change.
2. Have the admin settings held in an external database/spreadsheet that are read into the QlikView app every reload.

[#6]

Thank you very much guys. Very helpful indeed!