topic Re: Problem with month order in bar chart in QlikView

Problem with month order in bar chart

dcd123456 — Thu, 27 Feb 2014 08:58:27 GMT

Hello

I have a bar chart, i need to put the month of the year as dimension, in the data i have the date field and so i define a calculated dimension as year(H_MFECHA)&month(H_MFECHA).

The problem is that i have data from 03/2013 to 02/2014 and QV show in the bar chart 04/2013 as first month and 03/2013 as last month.

I attached an example.

thanks

regards

diego

Re: Problem with month order in bar chart

alexandros17 — Thu, 27 Feb 2014 09:22:28 GMT

Use this as dimension:

=year(H_MFECHA)*100+month(H_MFECHA)

Re: Problem with month order in bar chart

rustyfishbones — Thu, 27 Feb 2014 09:24:47 GMT

Hi,

Have you tried using changing the month to a number, like

and the use the SORT by numeric

Re: Problem with month order in bar chart

rustyfishbones — Thu, 27 Feb 2014 09:27:46 GMT

Sorry, I have noticed an issue with that.

Alessandro seems to have the correct Answer!

Re: Problem with month order in bar chart

mvanlutterveld — Thu, 27 Feb 2014 09:31:57 GMT

Hi Diego,

Add next line to your script and use the field YearMonth as the dimension of the graph.

Date(MonthStart(H_MFECHA),'YYYYMMM') as YearMonth

Regards,

Michiel

Re: Problem with month order in bar chart

Thu, 27 Feb 2014 09:42:35 GMT

use monthname() function

Re: Problem with month order in bar chart

CELAMBARASAN — Thu, 27 Feb 2014 09:49:45 GMT

To resolve in a chart

Add the below as dimension

=Date(MonthStart(H_MFECHA), 'YYYYMMM')

Set sort order Numeric as ascending

To do it in script is better choice

Re: Problem with month order in bar chart

PrashantSangle — Thu, 27 Feb 2014 09:51:10 GMT

Hi,

use monthname(H_MFECHA) as your dimension.

Re: Problem with month order in bar chart

dcd123456 — Thu, 27 Feb 2014 10:08:31 GMT

hello

with the dimension as =year(H_MFECHA)*100+month(H_MFECHA), the order of the month is correct but the display is like 201303 201304... it is possible to display the month like 2013mar 2013Apr ??

Thanks in advance for your help

regards

diego

Re: Problem with month order in bar chart

dcd123456 — Thu, 27 Feb 2014 11:54:46 GMT

Hello

with monthname(H_MFECHA) and =Date(MonthStart(H_MFECHA), 'YYYYMMM'), the order is not correct, mar2013 is the last month instead the first.

thanks

regards

diego

Re: Problem with month order in bar chart

rustyfishbones — Thu, 27 Feb 2014 11:59:35 GMT

Sort by Numeric Value maybe, not Y Value

Re: Problem with month order in bar chart

Thu, 27 Feb 2014 12:05:26 GMT

Create this variable in load statement

Re: Problem with month order in bar chart

dcd123456 — Thu, 27 Feb 2014 12:06:15 GMT

Perfect, with monthname(H_MFECHA) and sort by numeric Value the chart is correct

thanks

regards

diego

Re: Problem with month order in bar chart

sundarakumar — Thu, 27 Feb 2014 12:08:15 GMT

Hi,

go to sort tab

check expression

write "=num(H_MFECHA)"

uncheck ll other options.

it will sort correctly

Hope this helps.

-Sundar

Re: Problem with month order in bar chart

aveeeeeee7en — Thu, 27 Feb 2014 12:27:41 GMT

See the Attachment.

Regards

Aviral Nag