Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

Sorting to preserve a chronological order

I loaded an .xls file into QV. One of the fields contains dates in the format DD/MM/YYYY which must be sorted in QV so that, for example, January entries appear on the top-most row whereas December entries appear at the bottom. However, after sorting, March entries appear between July and August entries. Most of the field nevertheless has been properly sorted. Please advise on how to sort every entry in the chronological order described above.

5 Replies
MVP
MVP

Re: Sorting to preserve a chronological order

Hi

Sounds like something going wrong with the date formats when reading the file. Can you see the same problem in a simple QVW file that reads the same data source?

Make sure you read the date with an explicit conversion, such as

     Date(Date#(myField, 'DD/MM/YYYY'))

Are some of the dates left aligned in a list box - this would imply that these values are strings, not dates.

For more detailed diagnosis I suggest that you post a sample of the source data and QVW that illustrate the problem.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Sorting to preserve a chronological order

Thank you sir. An example of the problematic field in question after sorting appears below:

Not applicable

Re: Sorting to preserve a chronological order

Capture.PNG

MVP
MVP

Re: Sorting to preserve a chronological order

For more detailed diagnosis I suggest that you post a sample of the source data and QVW file that illustrate the problem.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Sorting to preserve a chronological order

Thank you again. Due to preservation of confidentiality requirements, I'm forbidden from supplying these items. I will follow your earlier advice and see if that works.