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
Discover how organizations are unlocking new revenue streams: Watch here
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
‎2010-02-18 10:31 AM

Sorting Dimension Values

Hi,

I'm a newbie on Qlikview so hopefully this is really easy to answer!

I'm bringing 2 years worth of data into a combo chart e.g. Apr-2008 to Mar-2010, but I actually only want to show the latest 12 months at one time i.e. April-2009 to Mar-2010. However when I check the Max Visible Number box and enter 12 on the presentation tab it brings back Apr-2008 to Mar-2009.

Is there an easy way to fix this?


Thanks in advance

267 Views
0 Likes
1 Reply
Not applicable
‎2010-02-18 10:41 AM
Author

If you switch your sorting to be Descending on that field, it should be the last 12. I don't know if there is a simple way to pull the last 12, but sort them in Ascending order.

A more versatile way to do this is to use Set Analysis on your expressions:

Sum({DateField={'>=$(=Max(DateField,12))'}>} Sales)


235 Views
0 Likes