Date Format

[laurapage]

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. 

[Anil_Babu_Samineni]

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

[Vegar]

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 ...

[laurapage]

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