topic Calendar Range in App Development https://community.qlik.com/t5/App-Development/Calendar-Range/m-p/1920949#M75810 <P>I need to create a calendar&nbsp; data range picker chart to display data based on most recent Timestamp, of each day.</P> <P>In Date picker, each day it should pick most recent timestamp and display the other record also.&nbsp;</P> <P>Extract,migrated,transform, load should be of KPI chart. I had attached sample dashboard display for reference.</P> <TABLE width="612"> <TBODY> <TR> <TD width="87">BATCH_DATE</TD> <TD width="61">BATCHID</TD> <TD width="72">MIGRATED</TD> <TD width="93">TRANSFORMS</TD> <TD width="48">LOADS</TD> <TD width="61">EXTRACT</TD> <TD width="190">INSERT_TIMESTAMP</TD> </TR> <TR> <TD>04/20/2022</TD> <TD>321</TD> <TD>463</TD> <TD>-</TD> <TD>3</TD> <TD>-</TD> <TD>2022-04-20 15:26:30.26302630</TD> </TR> <TR> <TD>04/20/2022</TD> <TD>401</TD> <TD>449</TD> <TD>-</TD> <TD>2</TD> <TD>917</TD> <TD>2022-04-20 15:26:30.26302630</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>281</TD> <TD>1128</TD> <TD>-</TD> <TD>1</TD> <TD>-</TD> <TD>2022-04-19 17:17:26.17261726</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>361</TD> <TD>1019</TD> <TD>-</TD> <TD>2</TD> <TD>2150</TD> <TD>2022-04-19 17:17:26.17261726</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>261</TD> <TD>-</TD> <TD>-</TD> <TD>1129</TD> <TD>-</TD> <TD>2022-04-19 14:16:18.16181618</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>341</TD> <TD>-</TD> <TD>-</TD> <TD>1021</TD> <TD>2150</TD> <TD>2022-04-19 14:16:18.16181618</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>1. for date picker by default it show the sum of&nbsp; all most recent timestamp of the day,</P> <P>ex: 463+1128 = 1591</P> <P>2. if we select other days, it should display the sum of most recent timestamp of that particular day.</P> <P>3. For example: on 04/19, we have 4 records with&nbsp; different timestamp, but by default it should show only recent timestamp of the day</P> <P>4. 04/20, there is no data present, so it should display as zero for all KPi's</P> Thu, 21 Apr 2022 12:47:41 GMT vikey 2022-04-21T12:47:41Z Calendar Range https://community.qlik.com/t5/App-Development/Calendar-Range/m-p/1920949#M75810 <P>I need to create a calendar&nbsp; data range picker chart to display data based on most recent Timestamp, of each day.</P> <P>In Date picker, each day it should pick most recent timestamp and display the other record also.&nbsp;</P> <P>Extract,migrated,transform, load should be of KPI chart. I had attached sample dashboard display for reference.</P> <TABLE width="612"> <TBODY> <TR> <TD width="87">BATCH_DATE</TD> <TD width="61">BATCHID</TD> <TD width="72">MIGRATED</TD> <TD width="93">TRANSFORMS</TD> <TD width="48">LOADS</TD> <TD width="61">EXTRACT</TD> <TD width="190">INSERT_TIMESTAMP</TD> </TR> <TR> <TD>04/20/2022</TD> <TD>321</TD> <TD>463</TD> <TD>-</TD> <TD>3</TD> <TD>-</TD> <TD>2022-04-20 15:26:30.26302630</TD> </TR> <TR> <TD>04/20/2022</TD> <TD>401</TD> <TD>449</TD> <TD>-</TD> <TD>2</TD> <TD>917</TD> <TD>2022-04-20 15:26:30.26302630</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>281</TD> <TD>1128</TD> <TD>-</TD> <TD>1</TD> <TD>-</TD> <TD>2022-04-19 17:17:26.17261726</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>361</TD> <TD>1019</TD> <TD>-</TD> <TD>2</TD> <TD>2150</TD> <TD>2022-04-19 17:17:26.17261726</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>261</TD> <TD>-</TD> <TD>-</TD> <TD>1129</TD> <TD>-</TD> <TD>2022-04-19 14:16:18.16181618</TD> </TR> <TR> <TD>04/19/2022</TD> <TD>341</TD> <TD>-</TD> <TD>-</TD> <TD>1021</TD> <TD>2150</TD> <TD>2022-04-19 14:16:18.16181618</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>1. for date picker by default it show the sum of&nbsp; all most recent timestamp of the day,</P> <P>ex: 463+1128 = 1591</P> <P>2. if we select other days, it should display the sum of most recent timestamp of that particular day.</P> <P>3. For example: on 04/19, we have 4 records with&nbsp; different timestamp, but by default it should show only recent timestamp of the day</P> <P>4. 04/20, there is no data present, so it should display as zero for all KPi's</P> Thu, 21 Apr 2022 12:47:41 GMT https://community.qlik.com/t5/App-Development/Calendar-Range/m-p/1920949#M75810 vikey 2022-04-21T12:47:41Z Re: Calendar Range https://community.qlik.com/t5/App-Development/Calendar-Range/m-p/1928143#M76435 <P>Can anyone please help me on this its little urgent. Thanks in advance!</P> Mon, 09 May 2022 17:02:34 GMT https://community.qlik.com/t5/App-Development/Calendar-Range/m-p/1928143#M76435 vikey 2022-05-09T17:02:34Z