Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
In the enclosed file I've added a Maste Calender (Presented as 'DATE' in the report).
I want to use the Maste Calender 'DATE' to filter out a date in the table in the report.
E.g. selecting '2016-12-05' as 'DATE' should show the same date in the table
Try giving the same field name for the Master calendar as well that is present in temp1, i.e., Date
load Distinct
Date as Date,
date(%CALENDARID, 'D.M.YYYY')as %CALENDARID,
//YEAR&'-'&WEEK as YearWeek,
Maste Calender 'DATE' works OK to f ilter out a 'Date, in the table whenI run it on my local PC.
Running the same report on our QlikView server it doesn't work.
I think that the problem is related to the date format.
On my local PC the 'DATE' format is 'YYYY-MM-DD'
On the QlikView server the 'DATE' format is 'YYYYMMDD'
Is there som setting that explains this?
Hi,
Can you please try use the attached code & replace in the Cal tab from line no: 82 to 102.
Regards,
Suresh Sindhigi
Works almost OK now.
The only problem I have is that the dateformat now is 'YYYYMMDD' instead of 'YYYY-MM-DD'
