Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CBRZ
Contributor
Contributor

Bar Chart Months

Is there a way to get the months on my bar chart to go in order (Jan, Feb, March.....)

Thanks!

6 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

Try in the properties of the chart on the "Sort" tab to set the sorting by the month of the first one and determine it in ascending order by numerical values.

Regards,

Andrey

klausskalts
Partner - Creator
Partner - Creator

Load the month names using the Month()-function (e.g. Month(Invopicedate) as Month and sort numerical.

awhitfield
Partner - Champion
Partner - Champion

Hi Cory,

check out the calendar etc in the attached example

Andy

CBRZ
Contributor
Contributor
Author

Hello Andrey, thank you for your help.

For some odd reason it still isn't working properly.  Any ideas?

awhitfield
Partner - Champion
Partner - Champion

Check out my example OR supply a sample qvw that contains your date.

Andy

klausskalts
Partner - Creator
Partner - Creator

Ho Cory,

How have you loaded the months-names?

  1. As dates using the month()-function
    In this case 'just' sort the months numericalAs text-information
  2. As text (from at text field)
    In this case you can - normally - use Sort-in-load-order

    In QlikView this is an option - in Sense its what happens when you un-check all other sort-options

OK?