Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
davehutchinson
Creator
Creator

Sorting by date not working??

Hi all.  I've looked through the other solutions to this, but none of them seem to be working for me.

 

I have a field "Date" in my data in the format of DD/MM/YYYY which I want to use in a line graph:

davehutchinson_0-1717075519529.png

In my load statement above, I've tried to get Qlik to recognise the days as a number so it'll put them in the right order, however when put into a line graph, the order is seemingly random?

I need the dates in date order, ascending from left to right. but Qlik is putting them in a random order and I can't work out why???

davehutchinson_1-1717075673195.png

In the sorting options, I've sorted numerically, ascending by the Date field.

 

Does anyone have any idea why its not putting them in order?

 

 

 

Labels (3)
1 Solution

Accepted Solutions
brunobertels
Master
Master

Hello 

put your date field that is in third place to first place in the sorting panel 

View solution in original post

2 Replies
brunobertels
Master
Master

Hello 

put your date field that is in third place to first place in the sorting panel 

davehutchinson
Creator
Creator
Author

OMG why didn't a try that in the first place!!! 🤣

That's great, thank you!!