Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date sort order in line chart

Hi all, this is driving me crazy :S I've tried everything that came to my mind, I combining 2 years in 1 chart using just month-day as dimension, but I cannot manage to get it sorted correctly, I'm already ordering by date field in load script and sort property in the dimension, but still, the dates not matching. Those at the end happen to be those days that were reported just in one year but not the other, any idea on how to solve this? Thanks in advance!

Dimension: Month([Report Date]) & '-' & Day([Report Date])

Sort: Expression -> [Report date]

I've also tried to create the dimension as text in load script and sort by load order but I'm getting the same result.

Capture.JPG.jpg

25 Replies
Anonymous
Not applicable
Author

Thanks Manish but it didn't work, it gave me even weirder resultsCapture.JPG.jpg

MK_QSL
MVP
MVP

Provide sample data.... please

Anonymous
Not applicable
Author

Here's is the sample file

MK_QSL
MVP
MVP

Change in script as below

  date([Report Date],'MMM-DD-YYYY') as [Report Date],

and try again..

ecolomer
Master II
Master II

can you see the file ...

Anonymous
Not applicable
Author

Hi Enrique,

     It is still not sorted correctly

Anonymous
Not applicable
Author

The only change is -dd- by -DD-?

I did it but nothing changed....

ecolomer
Master II
Master II

if you add the year?

Anonymous
Not applicable
Author

That's not the approach I want to overlap both years in 1 chart

travis_craven
Contributor
Contributor

I ran in to the same problem. I used Date(MonthStart(DateField), 'MMM-YYYY')  to resolve my issue.