topic Incremental Load - Show only Months No Quarters in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-Show-only-Months-No-Quarters/m-p/1289199#M853608 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">Hi All,</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">Dealing with strange&nbsp; scenarios in Incremental Load for our Project.</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">We have following kind of Data.</SPAN></P><P><SPAN style="font-size: 14pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 14pt;">ProcessID&nbsp;&nbsp;&nbsp; ProcessDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Metrics&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dimensions</SPAN></P><P><SPAN style="font-size: 14pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-01-01</SPAN></P><P><SPAN style="font-size: 14pt;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-02-01</SPAN></P><P><SPAN style="font-size: 14pt;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-03-01</SPAN></P><P><SPAN style="font-size: 14pt;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-04-01</SPAN></P><P><SPAN style="font-size: 14pt;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-05-01</SPAN></P><P><SPAN style="font-size: 14pt;">6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-06-01</SPAN></P><P><SPAN style="font-size: 14pt;">7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-0701</SPAN></P><P><SPAN style="font-size: 14pt;">and so on till December and continued till 2017 Feb</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">Here, 3,6,9 and 12 means&nbsp; Quarter as in Q1,Q2,Q3,Q4.</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11</SPAN></P><P><SPAN style="font-size: 14pt;">2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be&nbsp; 2015, 2016 (history QVD already created) and 2017 data is in database.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt;">Kindly help.</SPAN></P><P><SPAN style="font-size: 14pt;">Looking forward for valuable inputs.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Incremental Load - Show only Months No Quarters https://community.qlik.com/t5/QlikView/Incremental-Load-Show-only-Months-No-Quarters/m-p/1289199#M853608 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">Hi All,</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">Dealing with strange&nbsp; scenarios in Incremental Load for our Project.</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">We have following kind of Data.</SPAN></P><P><SPAN style="font-size: 14pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 14pt;">ProcessID&nbsp;&nbsp;&nbsp; ProcessDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Metrics&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dimensions</SPAN></P><P><SPAN style="font-size: 14pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-01-01</SPAN></P><P><SPAN style="font-size: 14pt;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-02-01</SPAN></P><P><SPAN style="font-size: 14pt;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-03-01</SPAN></P><P><SPAN style="font-size: 14pt;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-04-01</SPAN></P><P><SPAN style="font-size: 14pt;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-05-01</SPAN></P><P><SPAN style="font-size: 14pt;">6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-06-01</SPAN></P><P><SPAN style="font-size: 14pt;">7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2016-0701</SPAN></P><P><SPAN style="font-size: 14pt;">and so on till December and continued till 2017 Feb</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">Here, 3,6,9 and 12 means&nbsp; Quarter as in Q1,Q2,Q3,Q4.</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11</SPAN></P><P><SPAN style="font-size: 14pt;">2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be&nbsp; 2015, 2016 (history QVD already created) and 2017 data is in database.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt;">Kindly help.</SPAN></P><P><SPAN style="font-size: 14pt;">Looking forward for valuable inputs.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-Show-only-Months-No-Quarters/m-p/1289199#M853608 Anonymous 2020-11-25T16:16:04Z