Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
czehnder
Contributor
Contributor

Cannot get master calendar to sort ascending

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;

12 Replies
czehnder
Contributor
Contributor
Author

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
MVP & Luminary
MVP & Luminary

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

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