Solved: Date sorting issue in a line chart - Qlik Community

Just6 · ‎2021-09-17

Hallo, wie kann ich die gelb markierten Werte nach einer Formel sortieren? Leider fuktioniert die Sortierung nach aufsteigend nicht.

Danke für die Unterstützung!

Andre_Sostizzo · ‎2021-09-30

@Just6, when you export the data from the chart to a file, what is the order then, and is it exported as text or a long number? If exported as a number (the correct format for dates), you can try to maybe change the date formatting with the Date() function to see if the sorting behaves differently. If exported as text (because it's a dimension, or without $date sys tag), again try using the date() function in a measure (measures are exported as numeric values) as sorting will likely change when sorting the numeric values.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂

View solution in original post

NadiaB · ‎2021-09-24

Hi @Just6
What data type is that field?

Could it be possible for you to share a sample app?

Kind Regards.

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

Andre_Sostizzo · ‎2021-09-30

@Just6, when you export the data from the chart to a file, what is the order then, and is it exported as text or a long number? If exported as a number (the correct format for dates), you can try to maybe change the date formatting with the Date() function to see if the sorting behaves differently. If exported as text (because it's a dimension, or without $date sys tag), again try using the date() function in a measure (measures are exported as numeric values) as sorting will likely change when sorting the numeric values.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂

Date sorting issue in a line chart

Diagramm

Dimensiom

Formel