Discussion board where members can get started with QlikView.
I want to sort date that is in the format of dd/mm/yyyy
How will i do it?
use the "Sort" tab in the object properties window.
You can sort the field based on several conditions.
if you want to sort date in the script itself mean
load * inline [
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
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
go to sort tab
Select Numeric Value and do the sorting as per your require order... i.e. ascending or descending
goto Properties -->Numerb->Override Doc setting -->date -->format pattern -->dd/mm/yyyy
Used the dimension like this
if you are datedim as month use the script
Dual(Date(Datefield, 'dd/mm/yyyy'), monthstart(Datefield)) as datedim
Dual(Date(Datefield, 'dd/mm/yyyy'), daystart(Datefield)) as datedim
give the dimension datedim in desired charts and sort tab ----> numeric -----> asc