topic Re: question in QlikView

question

Thu, 03 Oct 2013 12:18:31 GMT

Hi everyone

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

How will i do it?

Anonymous — Thu, 03 Oct 2013 12:19:54 GMT

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

You can sort the field based on several conditions.

nizamsha — Thu, 03 Oct 2013 12:26:34 GMT

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

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

MK_QSL — Thu, 03 Oct 2013 12:27:22 GMT

go to sort tab

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

NavinReddy — Thu, 03 Oct 2013 12:32:20 GMT

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

v_iyyappan — Thu, 03 Oct 2013 12:59:04 GMT

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

regards,