A dynamic path for reload – Sense desktop - Qlik Community

dafnis14 · ‎2018-10-29

Hi,

I would like to enable the user to select the path to reload his data from (A list box).

So his selection updates a path variable in the FROM statement.

The user will reload in the conventional way, since there is no button in the UI.

I'm opened to use an extension, but not sure about the needed logic.

Any ideas?

Thanks!

undergrinder · ‎2018-10-30

Hi Dafnis,

I don't think the variable declared in UI have any effect on the load script.

If the user can perform a reload and he or she want to change a file a recommend the data manager instead.

General help on variables:

G.

MK9885 · ‎2018-10-30

Why not add a variable value in a text document, store it in somewhere in shared location?

the user would open the document and change the value to reload the app....

Create a new folder connection for your variable text

In that you can store

Let manual_loadflag = 'N'; // Y for Yes and N for No //

In your Qlik script store

LET vInclude_Directory = '..\Includes\Variables.txt';

IF '$(manual_loadflag)' = 'Y' THEN

Load

...

....

From...;

Else

Load

...

From....

This would mean an end user can open the text file, change the variable from Y to N depending on what he want