Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
No manish There is no problem in date field
Hi,
Look at the attached application.
Regards
ASHFAQ
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!!
Hi Vipin,
Actually this is a pivote table .sorting is not possible here as date is not the primary dimension.
Regards,
Subhranjali