Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide first 12 data points of MAT

Hi,

I have created a moving annual total using Rangesum and displayed this in a line chart with 13 rolling periods, however the totals start at 0 and then acumulating to the 13 periods. Is there anyway of excluding the first 12 data pionts?

2 Replies
Not applicable
Author

Goto Chart Properties > Dimension Limits > Then under the box titled "Limits "

Select the Option "Restrict the Values which are displayed using first express"

Then under the option "Show Only Values that are"

If you can send me the dimension values I can further help you.

Not applicable
Author

Hi

Thank you for your reply,

However i have version 10 which does not have Demension Limits function.

My dimension value is YearPeriod E.G 2009/10     1 and expression is sum of sales figure accumulated over 13 periods.