topic Reload Button by sending parameters to script in App Development

Reload Button by sending parameters to script

Luis_Saavedra — Sat, 16 Nov 2024 17:40:08 GMT

Dear Qlik Community

I have a QVDs’ snapshot from every day which are saved using the following named standard: “Reportname + _ + date” as follow:

BackupFinalReport_12-11-2020.qvd

BackupFinalReport_12-12-2020.qvd

BackupFinalReport_12-13-2020.qvd

BackupFinalReport_12-14-2020.qvd

BackupFinalReport_12-15-2020.qvd

And so on.

Right now, I am loading the last 2 QVD using 2 variables as follow and loading & concatenating the QVDs 2 times:

Let v BackupFinalReport1 = date(TODAY()-1,'YYYYMMDD');

Let vBackupFinalReport 2 = date(TODAY()-2,'YYYYMMDD');

CSPN_V2:

LOAD *

FROM [$(vPath)/ BackupFinalReport_$(vBackupFinalReport1).qvd] (qvd)

Concatenate

LOAD *

FROM [$(vPath)/ BackupFinalReport_$(vBackupFinalReport2).qvd] (qvd)

What I need to allow user to select the date directly on the app (by a filter or button) and then allow them to reload the app using the dates they selected,

For example, if the app has the data for 12-14-2020 and 12-15-2020 but they want to see the data for 12-11-2020 and 12-13-2020 I need to allow them to select the date, sent the date to variables already have in the script and reload the app with the dates values.

Is this possible? I hope to be clear enough.

Thanks a lot.

Re: Reload Button by sending parameters to script

Fernando_Fabregas — Tue, 29 Dec 2020 20:47:20 GMT

Hola Luis.

Two alternatives to do it in another way:

1) Instead, Today () you can use a value obtained from an Excel or .txt. The user must change that value before reload data.

2) Save the upload date in your model and reload all QVDs (if possible). Users can select this upload date to filter what they need.

(Saludos desde el barrio de Saavedra, Buenos Aires...)

Re: Reload Button by sending parameters to script

ArnadoSandoval — Fri, 01 Jan 2021 01:40:11 GMT

@Luis_Saavedra , @Fernando_Fabregas

Perhaps Dynamic Views is the way to go, this feature was introduced in February-March 2020, I haven't used it myself, but here are few videos and help pages, good luck:

Dynamic views - Qlik Sense
Introducing Dynamic Views (Mike Tarallo)
Qlik What If Analysis and Qlik Sense Dynamic Views - Episode 16 Webinar on BI (this one is 1 hour long, I haven't watch it
Creating dynamic views and charts (Help page)
Using dynamic views and charts (help page)
Managing data with dynamic views (help page -- You should read it)

I am suggesting you a Dynamic view because it allows you to run a Load Script from the User Interface and update visualizations, similar to your requirement, although you will have to adjust its logic to your need!

Please, let us know how you go with it, as I can't use on QlikSense Desktop.

Hope this helps,