Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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:MMSmiley FrustratedS, 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?

Tags (3)
1 Solution

Accepted Solutions

Re: Data Sorting Issue

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

4 Replies
khadeer_sparks
Valued Contributor

Re: Data Sorting Issue

Hi,

Use Date# function.

Date#(Format, Required Format).

Regards,

Khadeer

Re: Data Sorting Issue

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

Not applicable

Re: Data Sorting Issue

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

Hope it will work.

regards-bika

Not applicable

Re: Data Sorting Issue

This is the right solution!

Great!!