Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

Date Island table difficulties. How to solve this problem?

Hi,

I realise maybe this sounds a little vague but I am trying to see if there is a solution to this.

We have a Date Island table in Qlik which contains all the start and end dates of each month from 2012 to now.

This date island table is not associated with anything.

This date island table is created from a "Orders" table.

The date island table is then used for a Shipments table which is totally unconnected where using Set Analysis we compare a date in the shipments table against start and end date inside the date island table.

This makes the chart extremely performance heavy and takes over 5 minutes to load the chart!

How can I get rid of this date island approach which is used for comparison for the chart above?

2 Replies
andrey_krylov
Specialist
Specialist

Hi Michael, It is hard to say without seeing. Maybe, you can share this expression..

marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe you need to reverse the order of the datasets within the set analysis. Usually is something like this quite fast:

sum({< ShipmentDate = p(IslandOrderDate)>} Value)

maybe also with some <= >= against min/max(IslandOrderDate)

- Marcus