topic Re: A dynamic path for reload – Sense desktop in App Development

A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 08:38:54 GMT

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!

Re: A dynamic path for reload – Sense desktop

petter — Mon, 29 Oct 2018 08:48:03 GMT

As far as I know there is no good way of doing this without resorting to ODAG - On Demand App Generation or On-demand Apps. It should work very well for this kind of scenario - but don't let the Qlik marketing info mislead you.... ODAG is not only for "Big Data", it works very well for any kind of data - actually quicker and better for smaller data. It is the dynamics for the end-user being able to reload on the fly that is the important thing for your use case - not the Big Data thing.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/LoadData/creating-OnDemand-app.htm

Unfortunately the "learning curve" is a bit steep for just achieving the "dynamic path" but it is well worth the effort since you most likely will be able to use the On-demand Apps approach in other scenarios too later.

Re: A dynamic path for reload – Sense desktop

rubenmarin — Mon, 29 Oct 2018 08:54:26 GMT

Hi Dafnis, selections can't be used in script but variable values can be used, so you will need to use an extension that allows to store user selection in a variable that you can use in script.

There are many ways of doing this, a simple way canbe using this extension (Qlik Branch) and create a button for each option, if you need a selectable list, you will need a button that copies the value selected to the variable before reloading.

Re: A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 12:33:43 GMT

Hi Petter,

This is definitely contemporary..

Will look into it.

Thanks!

Re: A dynamic path for reload – Sense desktop

petter — Mon, 29 Oct 2018 12:41:22 GMT

I presume that you are asking about Qlik Sense Server and not Qlik Sense Desktop - am I right?

Re: A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 13:46:08 GMT

Hi Ruben,

I'm trying the extension you referred to.

Not sure how the variable can be defined. There is no option to select it..

What am I doing wrong?

Re a button to copy a selected value: does it need to be another extension?

Thanks!

Re: A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 14:18:58 GMT

I wrote in the subject line that I need it for Sense Desktop..

Re: A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 14:21:11 GMT

Hi Ruben,

I checked it with VizLib objects. The variable value is not saved, so reload doesn't recognize the path that the user selected.

do you have a sample app to share?

Re: A dynamic path for reload – Sense desktop

rubenmarin — Mon, 29 Oct 2018 16:57:49 GMT

Hi Dafnis, PFA, that's a simple sample of how variable values can change the file to load.

Extension for variable: Qlik Branch

Extension to reload: Qlik Branch

Re: A dynamic path for reload – Sense desktop

dafnis14 — Mon, 29 Oct 2018 18:10:03 GMT

Bingo!

just what I needed!

Somehow, the extension needs a refresh and then it's possible to select the variable.

Another "miracle" is the reload button, It generates an error message ("Reload Failed!) but reloads anyway.

Thanks!