Solved: Data Sorting Issue - Qlik Community

Report Inappropriate Content · ‎2013-07-23

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?

kaushiknsolanki · ‎2013-07-23

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

khadeer · ‎2013-07-23

Hi,

Use Date# function.

Date#(Format, Required Format).

Regards,

Khadeer

kaushiknsolanki · ‎2013-07-23

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-07-23

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

Hope it will work.

regards-bika

Report Inappropriate Content · ‎2013-07-23

This is the right solution!

Great!!

Data Sorting Issue