Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
CBRZ
New 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
Honored Contributor

Re: Bar Chart Months

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

Highlighted
Partner
Partner

Re: Bar Chart Months

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

Partner
Partner

Re: Bar Chart Months

Hi Cory,

check out the calendar etc in the attached example

Andy

CBRZ
New Contributor

Re: Bar Chart Months

Hello Andrey, thank you for your help.

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

Partner
Partner

Re: Bar Chart Months

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

Andy

Partner
Partner

Re: Bar Chart Months

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?