topic Re: Calendar object is not selecting the correct date range in QlikView

Calendar object is not selecting the correct date range

fashid — Fri, 22 Apr 2016 09:08:25 GMT

Hi Experts,

I am working on the canonical date concept in my application and i have created 2 master calendars for the same table .

One calendar works for filtering on the ENQ_DATE and the second calendar works on QUOTE_APPROVED_DATE.

In my app on the first sheet i am trying to use the FROM and TO date filter to work on the ENQ_DATE column in my table box , which works as expected .

Now on the second sheet i am trying to implement the same concept on the QUOTE_APPROVED_DATE column but somehow the filters

fail to work .

Could someone point out what the issue could be .

Regards,

Nadeem

Re: Calendar object is not selecting the correct date range

fashid — Mon, 25 Apr 2016 06:58:14 GMT

i am also attaching the sample QVD for the app

Re: Calendar object is not selecting the correct date range

MindaugasBacius — Mon, 25 Apr 2016 07:19:44 GMT

Check the connection of the field CALENDAR_QUOTE.CalendarDate. It have no values.

Re: Calendar object is not selecting the correct date range

fashid — Mon, 25 Apr 2016 07:46:52 GMT

Thanks for the reply Mindaugas ,but i cannot use the QUOTE_APPROVED_DT as it will not give me an entire range of dates(Missing dates in the QUOTE_APPROVED_DT field) .

If you see the first sheet the CalendarDate field correctly works for the ENQ_DATE .

I am just trying to replicate the same with a different calendar and different field name in the second sheet ,but somehow its not working .

Regards,

Nadeem

Re: Calendar object is not selecting the correct date range

MindaugasBacius — Mon, 25 Apr 2016 07:58:47 GMT

As I mentioned the field CALENDAR_QUOTE.CalendarDate is empty while CalendarDate is properly connected:

That's the main reason why you do see information in Sheet1 while in Sheet2 it do not work.

Re: Calendar object is not selecting the correct date range

fashid — Mon, 25 Apr 2016 10:42:03 GMT

Now even after disabling the first calendar the field is not getting mapped .

Is there some issue in my script ??

Re: Calendar object is not selecting the correct date range

fashid — Tue, 26 Apr 2016 05:39:26 GMT

Hello can anybody please help on this issue