topic Re: Maste Calender as filter in QlikView

Maste Calender as filter

stekol61 — Fri, 07 Apr 2017 09:16:53 GMT

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

arpitkharkia — Fri, 07 Apr 2017 09:25:27 GMT

Try giving the same field name for the Master calendar as well that is present in temp1, i.e., Date

MK_QSL — Fri, 07 Apr 2017 10:02:00 GMT

load Distinct

Date as Date,

date(%CALENDARID, 'D.M.YYYY')as %CALENDARID,

//YEAR&'-'&WEEK as YearWeek,

stekol61 — Fri, 07 Apr 2017 12:56:46 GMT

Hi!

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?

sureshsindhigi — Fri, 07 Apr 2017 13:28:13 GMT

Hi,

Can you please try use the attached code & replace in the Cal tab from line no: 82 to 102.

Regards,

Suresh Sindhigi

stekol61 — Mon, 10 Apr 2017 08:29:27 GMT

Hi!

Works almost OK now.

The only problem I have is that the dateformat now is 'YYYYMMDD' instead of 'YYYY-MM-DD'