Cannot get master calendar to sort ascending

[Anonymous]

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;

  Drop table tempPolicyCalendar;

[Anonymous]

That doesn't work, we aren't setting TempDate so I get and error that it can't find TempDate

Should this have been replaced by "Valuation Date" maybe?

Resident TempCalendar  Order By TempDate DESC;

[marcus_sommer]

There is a small error within it because TempDate weren't replaced everywhere:

ValuationCalendar:

Load

Date(Num) as "Valuation Date",

Date(floor(Monthend(Num))) AS "Valuation ME Date",

Date(Num,'DD/MM/YYYY') as "Valuation ME Date2",

Num as DateNo,

ApplyMap('QuartersMap',month(Num),Null()) as "Valuation Quarter"

Resident TempCalendar  Order By TempDate Num DESC;

- Marcus

[campbellr]

Hi Cherl

The reason you are getting only values in some lines for DateNo is you are using MM/DD/YYYY format for your dates but in that line you are usng DD/MM/YYYY in the assignment line:

NUM(DATE#(TempDate,'DD/MM/YYYY')) as DateNo,

So where the day of the month is 1-12 it is interpreting it as a date and the rest are not valid dates for that format

Ron