Interactive Dashboard based on dates selected by user

[qliksenseadminthomascook]

Dear All,

I want to create an interactive dashboard in which, if the user selects two dates, they should be passed as min date and max date. Also, we will give the user access to refresh the dashboard. So, if the user selects the dates and refreshes, only the specific data will be available in the dashboard for them to download. If they clear all selections and refresh, it should load all the data.

Any and all help is appreciated. Thanks in advance.

[JHuis]

You can use the date picker. If you use that it will select the Begin and End Date. 

If you dont want to use that you have to use set analysis.

Sum({<DateFIELD={">=Min(DateFIELD) <= Max(DateFIELD)"}>}MeasureField)

[qliksenseadminthomascook]

Hi JHuis,

I have already done that but the data is too big to be taken into excel file. So, we are storing the dump into csv file from the backend. So, if possible, I want to try that method where user can set the variable and reload the data accordingly.

Many thanks for your assitance.

[JHuis · Accepted solution]

Then ODAG would be a way to go. https://community.qlik.com/t5/Official-Support-Articles/How-to-Create-On-Demand-Applications-ODAG/ta...

Or dynamic views, what you prefer

[qliksenseadminthomascook]

Dear JHuis,

Thank you for your help. This worked out for me.