How to choose a specific date in the dashboard and update the data

[AmandaRo]

Hi! 

I am new to qlik sense, so i dont know if what i want it´s possible. 

To load my data i use the code:

Let vData1 = '2021-02-03';
Let vData2 = Date(DayEnd(vData1),'YYYY-MM-DD h:mm:ss');

Load *;
SQL

EXEC [procedure name] '$(vData1)', '$(vData2)';

'2021-02-03'  is an example. Is it possible to choose the data in the dashboard? Like, the user chooses the day he wants to analyze and clicks a button that replaces the variable Data1  with the chosen day and updates the data in the script. 

[sbarro1]

Hi,

A simple question! Why don't you load all data and let users decide directly in dashboard which period they'd wish to analyze (with a simple calendar for example)? Have you some huge volume data issue?

Personnally, I don't believe that's possible. And even if it is possible, it's probably very complex to do (I guess).

Regards.

[Ksrinivasan]

hi,

try this below link

https://community.qlik.com/t5/QlikView-App-Dev/Scripting-Load-Data-According-to-given-input-file-dat...

ksrinivasan