Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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
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