topic Chart sort order in QlikView

Chart sort order

Wed, 29 Dec 2010 22:10:26 GMT

Hey guys,

This is what I want to do... let's say I have a date as a dimension in a graph and it is currently sorted by descending order and Max Visible is set to 7.

ex: 12/7/10 12/6/10 12/5/10 12/4/10 12/3/10 12/2/10 12/1/10

I want that order to be reversed in the chart, but still have the descending order applied to it.

ex: 12/1/10 12/2/10 12/3/10 12/4/10 12/5/10 12/6/10 12/7/10

If I change the sort order to ascending, it'll give me earlier dates that I don't want. I guess a way to think about this would be like a nested sort... is there an easy way to just reverse the order on the chart? I can do this with set analysis probably pretty easily, just wondering if there was a quicker way for future reference.

And there's a "Reversed" checkbox in the Presentation tab that doesn't do what I want it to.

Chart sort order

pover — Wed, 29 Dec 2010 22:48:19 GMT

If the dimension is in ascending order and the reversed checkbox is selected with 7 max values visible and the scrollbar on the x-axis disabled, you should get what you want.

Regards.

Chart sort order

Wed, 05 Jan 2011 21:40:57 GMT

After playing around with it for a while, I got it to work. Thanks Karl.

Has anyone had problems with the "Reversed" option while using two dimensions?