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
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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: 
richard_chilvers
Specialist
Specialist
‎2015-07-13 08:36 AM

Restrict How Many Shown on X-Axis

I have a chart where the week number is the x-axis, and I wish to show the most recent 10 weeks.

I would usually do this by using a calculated dimension to restrict to 10 weeks, but my expressions use calculations which go back more than 10 weeks.

I hoped to use Dimension Limits, but it seems I can show the First 10 values, but there's no option to show the Last 10.

Any ideas are welcome.

Labels (1)
Labels
2,942 Views
0 Likes
10 Replies
sunny_talwar
MVP
MVP
‎2015-07-13 11:26 AM

In response to richard_chilvers

The idea makes sense. I have not used Dimension limits to know what the issue is, but I can suggest restricting the number of weeks to see using set analysis. If you can provide some sample data, I can show you how it can be done.

Best,

Sunny

245 Views
0 Likes