topic Create Button For Default Setting in QlikView

Create Button For Default Setting

Wed, 09 Mar 2011 17:11:21 GMT

I created a programme which includes a table for [COUNTRY], [EXCHANGE RATE], [MARKUP %] so on and so forth. I added a inputfield [EXHANGE RATE], so that the rate can vary when i click it.

The problem i face now is that, when i change the value of the exchange rate, and close the programme, and i open it back again, it would be the value which i changed. So lets say i changed the Rate for Malaysia from 2.4 to 2.6, and close the programme, it remains as 2.6. What i want is for the 2.6 to change back to 2.4 when i open up the file again.

Is there anyway for this to be achieved ? Thanks!

Create Button For Default Setting

matt_crowther — Wed, 09 Mar 2011 17:37:50 GMT

this should be possible using various actions:

Create a second variable (eg vExRateOriginal) and set this value to be your base value that you want to default to when opening (2.4). Now on open add a Trigger / Action that sets your first variable to be the contents of vExRateOriginal. You can then amend the first variable without altering the value in vExRateOriginal and it should always revert back to 2.4 each time the document is opened.

It may need a little alteration to meet your exact needs but hopefully that points you in the right direction.

All the best,

Matt - Visual Analytics Ltd

Create Button For Default Setting

pljsoftware — Wed, 09 Mar 2011 18:17:52 GMT

Hi Matt,

but if the qlikview document is on server and an user see it by remote access, the value of the variable is it saved too?

Create Button For Default Setting

matt_crowther — Wed, 09 Mar 2011 18:30:45 GMT

You'd have to undertake some experimentation to be sure but I've not had any issues with variables on a server (although not exactly this scenario).

You may even have nothing to worry about with a server deployment as users may well be able to amend variables via Input objects but not save them ergo the next time the .qvw is opened it has automatically reverted back to the original value -but as I say that would need some simple experimentation to find out how it behaves in the wild.

All the best,

Matt - Visual Analytics Ltd

Create Button For Default Setting

Thu, 10 Mar 2011 02:28:29 GMT

Thank you! it could work!