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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dimension limits

I want to manage the limit values of a dimension in a graph.

I have values for period field from 201501, 201502,.....until 201505, but I don't want to show 201505 value in my graph.

I have seen that I can manage the limit values of the dimension with conditions in the expresions.

Can I change the limit and refer to certain values?, for example: from 201501 to 201504.

Thanks in advance,

Juan

1 Reply
Anonymous
Not applicable
Author

You can limit it in script by not loading 201505, or use calculated dimension:

aggr(only(if(period<201505,period)),period)