topic Re: Show most recent data in Bar Chart in QlikView https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46618#M784648 <HTML><HEAD></HEAD><BODY><P>Instead you can use a calculated dimension which only take latest 10 periods</P></BODY></HTML> Mon, 19 Mar 2018 16:29:08 GMT shiveshsingh 2018-03-19T16:29:08Z Show most recent data in Bar Chart https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46617#M784647 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a bar chart in Qlikview 12 that shows Pay Periods (Fortnights) along the x axis. I wont to show only the 10 most recent periods with the most recent being on the right hand side of the chart. I note that the feature in Qlikview to restrict limits only allows you to show the First, while ideally I wont to show the Last. Any ideas?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196670_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46617#M784647 hogo1701 2020-11-25T16:16:04Z Re: Show most recent data in Bar Chart https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46618#M784648 <HTML><HEAD></HEAD><BODY><P>Instead you can use a calculated dimension which only take latest 10 periods</P></BODY></HTML> Mon, 19 Mar 2018 16:29:08 GMT https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46618#M784648 shiveshsingh 2018-03-19T16:29:08Z Re: Show most recent data in Bar Chart https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46619#M784649 <HTML><HEAD></HEAD><BODY><P>Thanks Shivesh. After further thought I decided it was best to retain all bars and have used an X axis scrolling bar to show only the most recent 12 periods, while having the ability to scroll back further. </P></BODY></HTML> Thu, 22 Mar 2018 02:57:50 GMT https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46619#M784649 hogo1701 2018-03-22T02:57:50Z Re: Show most recent data in Bar Chart https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46620#M784650 <HTML><HEAD></HEAD><BODY><P>Great then, please close the thread if your prob is resolved</P></BODY></HTML> Thu, 22 Mar 2018 15:36:45 GMT https://community.qlik.com/t5/QlikView/Show-most-recent-data-in-Bar-Chart/m-p/46620#M784650 shiveshsingh 2018-03-22T15:36:45Z