Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
irma
Partner - Contributor
Partner - Contributor

Displaying Multiple Date Ranges (Only Considering Date Information)

Hi everyone

I have an app in which I have the delivery date available as a calendar.

I would like to show the user the - possibly multiple - date ranges that are included in the current selection, e.g.

'01.01.2024-31.01.2024, 01.03.2024-31.05.2024'

When displaying these data ranges, however, only filter restrictions on the dates (date, month, year) should be taken into account. Further filter restrictions, e.g. on the product or delivery type, should be ignored. No date gaps should be displayed because there is no delivery for a date.

In the example above, the user would have selected the dates for January, March, April and May - but not for February. In addition, the user may have made numerous other filter selections, but these should be deliberately ignored in the display of the date range. If the user has not made any date restrictions, the entire period available in the calendar should be displayed.

I have tried various solutions (aggregations, alternative states), but I always fail because the date ranges refer to the actual deliveries. For example, days without deliveries result in two periods being displayed instead of one (e.g. '01.01.2024-04.01.2024, 06.01.2024-07.01.2024' instead of '01.01.2024-07.01.2024').

I hope I was able to explain my requirements clearly. I would be happy to receive any good advice.

Thank you very much!

Labels (4)
1 Reply
Rohan
Partner - Specialist
Partner - Specialist

Hi @irma ,

Create a mastercalendar, which will generate all the dates based on the min & max of your delivery date & link this mastercalendar back to the data by delivery date. That way you will have all the dates available to you in the front end..

 

Regards,
Rohan.