Problem for sorting date wise

[vipin_mishra479]

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]

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]

No manish There is no problem in date field

[ashfaq_haseeb]

Hi,

Look at the attached application.

Regards

ASHFAQ

[gopalopsharma]

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

[#6]

Hi Vipin,

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

Regards,

Subhranjali