Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Sorting Issue

Hi All,

i would sort the X-axis data of a line graphic.

It is a date format like DD-MM-YYYY HH:MM:SS, but it is presented on the graphic with this expression "=Month([date])&'/'&Year([date])" --> May/2013.

I tried many function like converting Date to String, but i have never been able to sort.

Could you help me please?

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

     Create a new field in your datamodel like

     Monthname(Date) as MonthName

     Then use thie field in your chart, this will be properly sorted.

     The format which this field will have by default is MMM YYYY.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

4 Replies
khadeer
Specialist
Specialist

Hi,

Use Date# function.

Date#(Format, Required Format).

Regards,

Khadeer

kaushiknsolanki

Hi,

     Create a new field in your datamodel like

     Monthname(Date) as MonthName

     Then use thie field in your chart, this will be properly sorted.

     The format which this field will have by default is MMM YYYY.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

Properties> Sort--Uncheck All & Check Load Order "Original"

Hope it will work.

regards-bika

Not applicable
Author

This is the right solution!

Great!!