Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shitijar
Partner - Contributor
Partner - Contributor

Sorting of bar graph showing previous 12 month data based on month selection

Hello Experts,

I have an Inventory bar chart showing previous 12 months data based on the current date selection.

Bar.PNG

The date selected is 30/11/2017 so it is showing (Quantity) from Nov-2016 to Oct-2017, which is correct
But the bar for Nov-16 and Dec-16 is shown in the last  i.e the sort order is
Jan-17, Feb-17, Mar-17, Apr-17, May-17, Jun-17, Jul-17, Aug-17, Sep-17, Oct-17, Nov-16, Dec-16

But I want the sort order to be

Nov-16, Dec-16, Jan-17, Feb-17, Mar-17, Apr-17, May-17, Jun-17, Jul-17, Aug-17, Sep-17, Oct-17



Please help me with the sorting part


Thanks in Advance



Regards,

Shitija Shetty

1 Reply
Anonymous
Not applicable

Looks like your dimension is simply the month.

If you use the month year as your dimension it should sort ok.  It will also be visually easier for you users to understand.