I have a chart with 48 months on the dimension. I am showing the last 12 month in the chart with a scrollbar. It needs to be an scroll function because I am using the above function in the expression. On the dashboard it say show reversed, so it will show always the last 12 months. Know I am using this chart in an report. But the report shows only the first 12 months. Somebody any idea how to show only the last 12 months in the report?
It is not uncommon that you need to create two versions of a chart, one for screen and one for print. There are many reasons for this - such as legends needing to be of a different size on the print version to the screen.
Given this you could create another version of the chart (on a hidden sheet) for use on the report. This could have Set Analysis in the expression to only ever show the last 12 months. As it is the print version then this will be fine.
Another option is to show all bars, QlikView should remove the legends from some bars if they won't fit and the trend will be shown on the chart. If you only want twelve bars you can make the appropriate selections before printing.
Thank you for your reply. It is no problem to create another chart on an hidden sheet. The problem is that the calculation won't see values of the years before. I added an example of my problem.
Hi there - thanks for posting up the example. I can see the issue now, due to the usage of the Above statement. You may be able to deal with this by using Set Analysis to look at four months in each expression - rather than the using the Above statement.
