Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
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.
View solution in original post
Use Date# function.
Date#(Format, Required Format).
Properties> Sort--Uncheck All & Check Load Order "Original"
Hope it will work.
This is the right solution!