This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!