In my Qlik Sense app I have codes with start and close timestamps, and a calendar dimension (link_date_time_15min) that consist of timestmaps with 15 minute intervals.
On a table I'm using a master dimension defined as:
=if('$(=close_timestamp)'>=link_date_time_15min AND '$(=start_timestamp)'<=link_date_time_15min, timestamp(link_date_time_15min,'hh:mm'))
When I pick a code, I'm seeing on the table the list of link_date_time_15min between close and start timestamp, which is what I was looking for, but while calculating the result the CPU and memory go to 100% and sometimes my app becomes unresponsive.
Do you know of any other method to achieve the same results but with better performance?