topic Re: Input Box refresh on server in QlikView

Input Box refresh on server

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm having several problems to solve this situation:

I have a inputBox that saves the value of variable to use when i reload the server.

It works for me in Desktop.

The problem is that when i put my document on server and it does the reload i lost the input value and it returns to original variable value. Only changes if i put a new value in Desktop application.

It's necessary because the finality of this inputBox is to perform an action after reload.

Thanks in advance.

Re: Input Box refresh on server

Anonymous — Sat, 02 Jul 2016 16:28:33 GMT

Hi Ivan,

I had the same problem: I solved it using an excel instead of the input box...

I read the value from the exel and set the variable in the script.

I think it's not possible set a variable on access point and saved it..

Elena

Re: Input Box refresh on server

maksim_senin — Sun, 03 Jul 2016 23:01:24 GMT

Hi Ivan,

Elena's input makes sense. Also please refer to documentation of KliqPlan and KliqTable, these components allow to input and store data via QV.

Best regards,

Maxim

Re: Input Box refresh on server

Mon, 04 Jul 2016 07:08:41 GMT

Hi Elena,

Thanks for you reply.

It's possible a good idea but, can you tell me how to do it?

You put the value you want in excel file and then reload? Have you any example?

Thanks!

Re: Input Box refresh on server

Anonymous — Mon, 04 Jul 2016 08:19:37 GMT

Hi Ivan,

yes, users can write the value in a Excel that is put on a share, then they can relaod the application with an external procedure (the application is relaoded automatically every night, but users can relaod during the day, if they need).

In the script I write:

VALUE:

LOAD

Value as MargineMin

FROM Excel.xlsx (ooxml, embedded lables, table is [Parameter ]);

LET v_Value = peek('MargineMin', 0, 'VALUE');

BR,

Elena

Re: Input Box refresh on server

Mon, 04 Jul 2016 12:59:23 GMT

Hi Elena,

Finally i'm going to implement this solution because i can't found other way to solve it.

Thanks for the support!