topic Re: Interactive Dashboard based on dates selected by user in App Development

Interactive Dashboard based on dates selected by user

qliksenseadminthomascook — Fri, 25 Jul 2025 13:00:27 GMT

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.

Re: Interactive Dashboard based on dates selected by user

JHuis — Fri, 25 Jul 2025 13:25:50 GMT

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)

Re: Interactive Dashboard based on dates selected by user

qliksenseadminthomascook — Mon, 28 Jul 2025 05:50:48 GMT

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.

Re: Interactive Dashboard based on dates selected by user

JHuis — Mon, 28 Jul 2025 06:27:48 GMT

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

Or dynamic views, what you prefer

Re: Interactive Dashboard based on dates selected by user

qliksenseadminthomascook — Mon, 28 Jul 2025 13:25:12 GMT

Dear JHuis,

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