sort in minichart

[Anonymous]

Hi,

I've made a minichart where months is the dimension. If i look at the values in the list box they are represented correct. Hence;

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

But in my minichart the first value is from April. What am i doing wrong?

Thanks in advance,

//A.

[kaushiknsolanki]

Hi,

   Can you upload the Qvw file.

Thanks,

Kaushik Solanki

[derekjones]

Is it presenting the data alphabetically? i.e.

Apr

Aug

Dec

Feb

Jan

Jul

Jun

Mar

May

Nov

Oct

Sep

[Anonymous]

Yes, it does.

[kaushiknsolanki]

Hi,

    Try this

    Go to the properties of chart-> sort- >select the minichart expression> select load order

Regards,

Kaushik Solanki

[Anonymous]

Problem is that i've made this minichart in the listbox as an expression. The only thing i can sort is the dimension in the list box so to speak.

//A.

[derekjones · Accepted solution]

OK, then you could try adding a table to store Month and Month Number (see below). This way you can add a sort field of Month_No to your chart and keep it hidden so only Month Name shows?

Probably not the cleanest way of doing it, but it works.

Month	Month_No
Jan	1
Feb	2
Mar	3
Apr	4
May	5
Jun	6
Jul	7
Aug	8
Sep	9
Oct	10
Nov	11
Dec	12

[derekjones]

See attached example...

[Anonymous]

Understood.

Yes your minicharts is sorted alphabetic, I dont think there is a way to sort this in your minicharts (as far as I know)

You should do this in your script, some how.

But I think DerekJones answer is the easiest. Then you can just change the dimension of your mini charts to Month_No , right?

[Anonymous]

Yes! That'll do it! Thanks!

But have another problem that's similar. Maybe i should do the same thing but i have a MonthYear filed aswell in this format;

Apr-2009

And this one is also sorted alphabetical at the moment.

//A.