topic Re: Master calendar in QlikView

Master calendar

tomcatxx — Wed, 25 Nov 2020 16:16:04 GMT

Hi there, I have a Problem about calendar. That calender contains 14 days. Code is here.

//////////////////////////////////////////////////////////////

LET varMinDatum = Today()-14;
LET varMaxDatum = Today()+1;

Kalender:
LOAD *,
AutoNumber(%Datum, 'Schichttag') AS _D,
AutoNumber(Woche, 'Woche') AS _W,
AutoNumber(Jahr, 'Jahr') AS _J,
AutoNumber(Monat, 'Monat') AS _M,
AutoNumber(Quartal, 'Quartal') AS _Q;

LOAD Datumsfeld as %Datum,
week(Datumsfeld) as Woche,
year(Datumsfeld) as Jahr,
month(Datumsfeld) as Monat,
day(Datumsfeld) as Tag,

LOAD date($(varMinDatum)+IterNo()-1) as Datumsfeld
AUTOGENERATE 1 WHILE $(varMinDatum)+IterNo()-1<= $(varMaxDatum);

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Now I have data only on 03.05 , 04. 05, 11,05. For other days I have no data. But that shows only values of date for these 3 days.

%Datum
27.04.2018
28.04.2018
29.04.2018
30.04.2018
01.05.2018
02.05.2018
43223
43224
05.05.2018
06.05.2018
07.05.2018
08.05.2018
09.05.2018
10.05.2018
43237
12.05.2018

The data must be updated everyday with Join, when there are new data.

Load * From xxx;

Join

Load xx,

xx,

Today() as %Datum;

Re: Master calendar

YoussefBelloum — Fri, 11 May 2018 08:36:10 GMT

Hi,

try this:

Load * From xxx;

Join

Load xx,

xx,

Date(Today()) as %Datum;

Re: Master calendar

tomcatxx — Fri, 11 May 2018 09:00:34 GMT

Thank you. I thought it must work.

I tried it and Date(Today(), 'DD.MM.YYYY') as %Datum and FileTime() as %Datum.

But they don't work.

Re: Master calendar

YoussefBelloum — Thu, 17 May 2018 11:48:21 GMT

Would you be able to attach sample data or app ?

Re: Master calendar

tomcatxx — Thu, 17 May 2018 12:19:23 GMT

I tried it again. It works now. I think u are right. I missed something.

I have app like this.

Datasource.txt------>Generator.qvw------->Data_model.qvw-------> Dashborad.qvw------->Nprinting------>Excel

I just corrected Date(Today()) as Datum in Generator.qvw. But the data will be loaded one more time in Data_model.qvw. I didn't change Datum as %Datum in Data_model.qvw. So it didn't work.

Now I have also Date(Datum) as %Datum in Data_model.qvw. So it's perfect now.

Thank you.

Re: Master calendar

YoussefBelloum — Thu, 17 May 2018 12:22:03 GMT

you're welcome.

Good luck