Handle Multiple Dates for large dataset

[T_Qlik]

I have a main table with 5 dates for Retail dashboard. How I can handle dates?

one way is to concatenate and create flag for each date but this is causing 'Out of memory error'

as app size going past 5 GB.

Main Table >> 15 million records

Main:

Load *,

Date1,

Date2,

Date3,

Date4,

Date5

;

Select * from Main;

Calendar:

Load

Date as Date1,

Month,

Year

;

UI requirement: I have 5 sheets, each sheet charts need to be restricted based on different dates.

eg: Sheet 1 Charts (Date1), Sheet 2 Charts (Date2)...

[T_Qlik]

Concatenate will cause 15*5 = 75 million records just to create flag