Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

corybrzak
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

klausskalts
Contributor

Re: Bar Chart Months

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

awhitfield
Esteemed Contributor

Re: Bar Chart Months

Hi Cory,

check out the calendar etc in the attached example

Andy

corybrzak
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?

awhitfield
Esteemed Contributor

Re: Bar Chart Months

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

Andy

klausskalts
Contributor

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?


Community Browser