Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AmandaRo
Contributor
Contributor

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

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. 

Labels (6)
2 Replies
sbarro1
Contributor II
Contributor II

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
Specialist
Specialist