Show most recent data in Bar Chart

[hogo1701]

Hi

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?

[shiveshsingh]

Instead you can use a calculated dimension which only take latest 10 periods

[hogo1701]

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.

[shiveshsingh]

Great then, please close the thread if your prob is resolved