topic Dynamic Fuctionality in QlikView

Dynamic Fuctionality

Tue, 05 Aug 2014 10:55:13 GMT

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?

Re: Dynamic Fuctionality

deepakqlikview_123 — Tue, 05 Aug 2014 10:58:41 GMT

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

Re: Dynamic Fuctionality

Tue, 05 Aug 2014 11:04:52 GMT

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?

Re: Dynamic Fuctionality

deepakqlikview_123 — Tue, 05 Aug 2014 11:08:39 GMT

Hi Tumelo,

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

Thanks,

Re: Dynamic Fuctionality

DavidFoster1 — Tue, 05 Aug 2014 11:29:29 GMT

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.

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

Re: Dynamic Fuctionality

Tue, 05 Aug 2014 11:53:16 GMT

Thank you very much guys. Very helpful indeed!