topic Re: Sorting Axis in QlikView

Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 08:54:07 GMT

Hallo,

I hope anybody can help me.

How can I sorting the axis in the Diagramm?

The dimension of the axis consists of the combination of the fields year & month. I want to display the months of each year in the logical order (Starting for example with 2016January,2016 February ..than 2017January...and so on.).

Thank you very much in advance for help.

Re: Sorting Axis

YoussefBelloum — Tue, 06 Mar 2018 08:56:50 GMT

Hi,

I suppose that you have Date field, on the sorting options, uncheck all and put this expression on ascending:

=Max(Date)

PS: Date is your Date field, so if it not called Date, Use your Date field name.

Re: Sorting Axis

karthikoffi27se — Tue, 06 Mar 2018 08:57:03 GMT

Hi Cathleen

You can use sort by numerical value descending order which will sort all you month values properly.

Many Thanks

Karthik

Re: Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 09:15:06 GMT

Hi,

thank you for the Information.

I can use this formula if I only select a date field (Year or Month). But I have two columns (year and month) which I would like to combine (year & month) and then want to show sorted.

I have Change the Diagramm.

Have a nice day.

Re: Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 09:15:31 GMT

Thank you

Re: Sorting Axis

sasiparupudi1 — Tue, 06 Mar 2018 09:20:33 GMT

May be use the expression MakeDate(Year,Month,1) in the sort page

Re: Sorting Axis

YoussefBelloum — Tue, 06 Mar 2018 09:26:30 GMT

Ah ok, you mean that you don't already have a Date field ?

Re: Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 09:32:11 GMT

I have connected year and month as a data field (makeDate). However, sorting with the formula "max (date)" does not work

I used the following Expression (I got an error)

=Max(MakeDate(JahrT,MonatT))

Re: Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 09:33:41 GMT

Hi, I created a new Date field: MakeDate(JahrT,MonatT) . Now I want to sort the new Date field in the correct sequence

Re: Sorting Axis

YoussefBelloum — Tue, 06 Mar 2018 09:45:54 GMT

it does not work because your Month field are not numeric..

try this:

=MakeDate(JahrT,num(month(date#(MonatT,'MMM'))))

and try to use it on the sorting with max

Re: Sorting Axis

YoussefBelloum — Tue, 06 Mar 2018 09:52:10 GMT

and even this will not work for all your rows, because, on the the Monthnames, you should have this

Set MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

and you have values like: Mrz, Dez, Okt...

you can rename the variable on the script with the values you have.

Re: Sorting Axis

caniwhz1 — Tue, 06 Mar 2018 10:12:28 GMT

Great. It works. Thank you.