topic Re: Re: Problem for sorting date wise in QlikView

Problem for sorting date wise

vipin_mishra479 — Thu, 10 Jul 2014 08:20:23 GMT

Hi All,

I have facing proble to sort my data on date wise how can i do this.please suggest.

Here i attached qvw file

MK_QSL — Thu, 10 Jul 2014 08:28:48 GMT

may be problem in your date field... Try below for date in your script or UI end and use the same for sort in expression..

=Date(Date#(Date,'MM/DD/YYYY'))

vipin_mishra479 — Thu, 10 Jul 2014 08:39:33 GMT

No manish There is no problem in date field

ashfaq_haseeb — Thu, 10 Jul 2014 09:01:48 GMT

Hi,

Look at the attached application.

Regards

ASHFAQ

gopalopsharma — Thu, 10 Jul 2014 09:02:13 GMT

Hello Vipin,

THis is happening because you have put the date after other fields.

so QV is first sorting the columns above then sorting date..

To solve Promote the Date dimension to II place after Property..

Hope this helps!!

Thu, 10 Jul 2014 09:34:00 GMT

Hi Vipin,

Actually this is a pivote table .sorting is not possible here as date is not the primary dimension.

Regards,

Subhranjali