https://community.qlik.com/t5/Featured-Members/Handle-Multiple-Dates-for-large-dataset/m-p/2124692#M166 <P>Concatenate will cause 15*5 = 75 million records just to create flag</P> Tue, 03 Oct 2023 12:32:30 GMT T_Qlik 2023-10-03T12:32:30Z https://community.qlik.com/t5/Featured-Members/Handle-Multiple-Dates-for-large-dataset/m-p/2124689#M165 <DIV> <DIV><SPAN>I have a main table with 5 dates for Retail dashboard. How I can handle dates?</SPAN></DIV> <DIV><SPAN>one way is to concatenate and create flag for each date but this is causing </SPAN><SPAN>'Out of memory error'</SPAN></DIV> <DIV><SPAN>as app size going past 5 GB.</SPAN></DIV> <BR /> <DIV><SPAN>Main Table &gt;&gt; 15 million records</SPAN></DIV> <BR /> <DIV><SPAN>Main:</SPAN></DIV> <DIV><SPAN>Load *,</SPAN></DIV> <DIV><SPAN>Date1,</SPAN></DIV> <DIV><SPAN>Date2,</SPAN></DIV> <DIV><SPAN>Date3,</SPAN></DIV> <DIV><SPAN>Date4,</SPAN></DIV> <DIV><SPAN>Date5</SPAN></DIV> <DIV><SPAN>;</SPAN></DIV> <DIV><SPAN>Select * from Main</SPAN><SPAN>;</SPAN></DIV> <BR /> <DIV><SPAN>Calendar:</SPAN></DIV> <DIV><SPAN>Load</SPAN></DIV> <DIV><SPAN>Date as Date1,</SPAN></DIV> <DIV><SPAN>Month,</SPAN></DIV> <DIV><SPAN>Year</SPAN></DIV> <DIV><SPAN>;</SPAN></DIV> <BR /><BR /> <DIV><SPAN>UI requirement: I have 5 sheets, each sheet charts need to be restricted based on different dates.</SPAN></DIV> <DIV><SPAN>eg: Sheet 1 Charts (Date1), Sheet 2 Charts (Date2)... </SPAN></DIV> </DIV> Tue, 03 Oct 2023 12:31:27 GMT https://community.qlik.com/t5/Featured-Members/Handle-Multiple-Dates-for-large-dataset/m-p/2124689#M165 T_Qlik 2023-10-03T12:31:27Z https://community.qlik.com/t5/Featured-Members/Handle-Multiple-Dates-for-large-dataset/m-p/2124692#M166 <P>Concatenate will cause 15*5 = 75 million records just to create flag</P> Tue, 03 Oct 2023 12:32:30 GMT https://community.qlik.com/t5/Featured-Members/Handle-Multiple-Dates-for-large-dataset/m-p/2124692#M166 T_Qlik 2023-10-03T12:32:30Z