topic Re: Data Sorting Issue in QlikView

Data Sorting Issue

Tue, 23 Jul 2013 10:34:00 GMT

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?

khadeer — Tue, 23 Jul 2013 10:37:37 GMT

Hi,

Use Date# function.

Date#(Format, Required Format).

Regards,

Khadeer

kaushiknsolanki — Tue, 23 Jul 2013 10:38:43 GMT

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

Tue, 23 Jul 2013 10:42:36 GMT

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

Hope it will work.

regards-bika

Tue, 23 Jul 2013 10:49:48 GMT

This is the right solution!

Great!!