Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shitijar
New 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

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

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.

Community Browser