Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
caniwhz1
Contributor III
Contributor III

Sorting Axis

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.

11 Replies
YoussefBelloum
Champion
Champion

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.

karthikoffi27se
Creator III
Creator III

Hi Cathleen

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

Many Thanks

Karthik

caniwhz1
Contributor III
Contributor III
Author

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.

caniwhz1
Contributor III
Contributor III
Author

Thank you

sasiparupudi1
Master III
Master III

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

YoussefBelloum
Champion
Champion

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

caniwhz1
Contributor III
Contributor III
Author

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))

caniwhz1
Contributor III
Contributor III
Author

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

YoussefBelloum
Champion
Champion

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