Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

question

Hi everyone

I want to sort date that is in the format of dd/mm/yyyy

How will i do it?

5 Replies
Highlighted
Specialist
Specialist

use the "Sort" tab in the object properties window.

You can sort the field based on several conditions.

Highlighted
Specialist II
Specialist II

if you want to sort date in the script itself mean

suppose eg:

table1:

load * inline [

date

1/2/2012

1/1/2012

];

table2:

load date resident table1 order by date;

y i am creating date in another table mean u cant use order by in current table,order by can be used in resident table only

now u will get the date like this

1/1/2012

1/2/2012

or

if u want date  ascending or descending in listbox mean u can go to sort tab in your listbox in that u can use ascending or descending

Highlighted
MVP
MVP

go to sort tab

Select Numeric Value and do the sorting as per your require order... i.e. ascending or descending

Highlighted
Creator II
Creator II

goto Properties -->Numerb->Override Doc setting -->date -->format pattern -->dd/mm/yyyy

Highlighted
Specialist
Specialist

Used the dimension like this

if you are datedim as month use the script

Dual(Date(Datefield, 'dd/mm/yyyy'), monthstart(Datefield)) as datedim

or

Dual(Date(Datefield, 'dd/mm/yyyy'), daystart(Datefield)) as datedim

give the dimension datedim in desired charts and sort tab ----> numeric -----> asc

regards,