Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

A dynamic path for reload – Sense desktop

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!

2 Replies
undergrinder
Specialist II
Specialist II

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:

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Variables/create-va...

G.

MK9885
Master II
Master II

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