Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Limit the number of displayed dimensions on chart

Hi,

I have a chart, that has 2 dimensions (year and Half year).

As a measurement, I have the following expression:

(RangeSum( Above(TOTAL sum([Palautus yhteensä])+SUM([Maksu ulos]), 0, NoOfRows(TOTAL))))+SUM(Valuation)

pic1.png

Question: How do I limit the number of dimensions displayed? For example, If I would like only to display all H1/H2 from 2011 till 2016 and leave 2010 away from the chart. But As it is a cumulative formula, the values from previous years should still be displayed in the charts periods. Is this possible to do?

Thanks for the help!