topic sort in minichart in QlikView

sort in minichart

Anonymous — Mon, 23 May 2011 12:27:35 GMT

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.

sort in minichart

kaushiknsolanki — Mon, 23 May 2011 12:33:16 GMT

Hi,

Can you upload the Qvw file.

Thanks,

Kaushik Solanki

sort in minichart

derekjones — Mon, 23 May 2011 12:36:47 GMT

Is it presenting the data alphabetically? i.e.

Apr

Aug

Dec

Feb

Jan

Jul

Jun

Mar

May

Nov

Oct

Sep

sort in minichart

Anonymous — Mon, 23 May 2011 12:39:31 GMT

Yes, it does.

sort in minichart

kaushiknsolanki — Mon, 23 May 2011 12:41:05 GMT

Hi,

Try this

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

Regards,

Kaushik Solanki

sort in minichart

Anonymous — Mon, 23 May 2011 12:43:35 GMT

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.

sort in minichart

derekjones — Mon, 23 May 2011 12:46:14 GMT

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

Re: sort in minichart

derekjones — Mon, 23 May 2011 12:49:26 GMT

See attached example...

sort in minichart

Anonymous — Mon, 23 May 2011 13:01:30 GMT

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?

sort in minichart

Anonymous — Mon, 23 May 2011 13:21:13 GMT

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.

sort in minichart

Anonymous — Mon, 23 May 2011 13:29:50 GMT

Did you create a calendar?

If you do you can add the following line to it:

ORDER BY Datefield asc;

Where Datefield is the field you use to autogenerate your calander from.

Re: sort in minichart

derekjones — Mon, 23 May 2011 13:30:30 GMT

Hi borgannika

Tip on Month Year (or any dating). If you use the format of YYYYMMDD (or YYYYMM in your case) you will always have a sortable date field.

sort in minichart

Anonymous — Mon, 23 May 2011 13:35:47 GMT

Thank you! Don't know why i'm so stubborn with the MonthYear field. YearMonth is better in so many ways 😃

thanks!