Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Specialist
Specialist

Hi,

Use Date# function.

Date#(Format, Required Format).

Regards,

Khadeer

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Not applicable

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

Hope it will work.

regards-bika

Highlighted
Not applicable

This is the right solution!

Great!!