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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-02-15 09:42 AM

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!

327 Views
0 Likes
0 Replies