topic Re: Calendar issue in QlikView

Calendar issue

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

Hi.

Once upon a time, we have a calendar application and another application had a fiscal calendar and now the fiscal calendar is the main app and I am trying to integrate the calendar year application into the fiscal application.

But my calendar is not connecting even though it shows in the design.

Anyone any ideas.

On the front, once compiled, the Date field should load.

It does in my real application but when bringing in the calendar year application, it aint.

Any ideas appreciated.

Re: Calendar issue

bobbydave — Mon, 21 Sep 2015 14:42:20 GMT

Anyone?

Re: Calendar issue

marcus_sommer — Mon, 21 Sep 2015 17:47:51 GMT

At the moment I couldn't look into app but I think this will be very helpful for you: How to use - Master-Calendar and Date-Values

- Marcus

Re: Calendar issue

MarcoWedel — Mon, 21 Sep 2015 22:09:54 GMT

Hi,

I guess the "CallsDate" field ("Calls.Date" field in your A_Call.qvd) and your "FiscalYearPeriod" field in T_Calendar.qvd do not contain matching values, thus "Where Exists (%FiscalYearPeriod, FiscalYearPeriod);" will never be true.

regards

Marco

Re: Calendar issue

bobbydave — Tue, 22 Sep 2015 07:54:21 GMT

You are right.

My main application has dates coming in in fiscal month year format YYYYMM from the QVD.

The part I am trying to bring in (the qvw that I attached) from the QVD is DD/MM/YYYY. I am going back to that loader now and changing it to Fiscal Year Month format so that when I load it now, it will be in Fiscal format from the start.

Thanks for the advice and the help.

Much appreciated.