In QlikSense I've been trying to sort my master calendar by most recent date first. Everything I read says it would work but it doesn't. I even did the following: saved to a qvd, loaded the qvd into a temporary calendar then load it sorted, still doesn't work.
Any idea what i'm doing wrong?
TempPolicyCalendar: LOAD * FROM [lib://QVD/PolicyCalendar.qvd](qvd) ;
PolicyCalendar: Load * Resident tempPolicyCalendar Order By "Policy Date" DESC;