topic Re: Date Format in QlikView

Date Format

laurapage — Sat, 16 Nov 2024 03:42:17 GMT

I have loaded a set of data based on dates. I have created my chart, but for the life of me I cannot get the data to be sorted by calendar function rather than descending order.

The date format is DD/MM/YYYY and is recognised as Data in the excel sheet.

I am trying to amend the sorting category, and sort by this field, however I cannot figure out what the expression should be to organise by chronological order.

Re: Date Format

Anil_Babu_Samineni — Wed, 01 May 2019 08:26:16 GMT

How is the input looks like that? And how you are getting data? Can you convert that to Number format like

Num(DateField) as Expression and Ascending order

Re: Date Format

Vegar — Wed, 01 May 2019 08:26:56 GMT

You can tell Qlikview that your excel column I formatted as DD/MM/YYYY by loading it like this:

LOAD

DATE#(DateColumn, 'DD/MM/YYYY') as DateColumn,

...

FROM ...

Re: Date Format

laurapage — Wed, 01 May 2019 13:15:28 GMT

Thanks for options. It seemed that when i changed it to YEar.Qtr then it seemed to work.