Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input Box refresh on server

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

maksim_senin
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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!

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi Elena,

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

Thanks for the support!