topic Re: Explain in QlikView

Explain

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

Hi Expertise ,

Can someone please explain me what does the below script do exactly . I really dont understand this .

And why is the + symbol ? what is IterNO()-1 ?

LOAD

Date(MinDate + IterNo() -1,'DD/MM/YYYY') as Date,
Date(MinDate + IterNo() -1,'YYYY') as Year,

Date(MinDate + IterNo() -1,'YY') & '_' & Num(Week(MinDate + IterNo() -1),'00') as Week

While
MinDate + IterNo() -1 <=MaxDate;

LOAD
min(Date) as MinDate,
max(Date) as MaxDate
Resident Event_TAble;

Thanks,

In Advance

Re: Explain

Anil_Babu_Samineni — Thu, 04 Jun 2020 07:13:44 GMT

Nothing, From this table "Event_TAble" It will generate Min and Max Dates.

Then, While loop running from Min to Max date whatever date/year/week fields will be generate missing dates from Iterno() as per dat from "Event_TAble" this table available.

Re: Explain

smilingjohn — Thu, 04 Jun 2020 07:22:29 GMT

Thanks @Anil_Babu_Samineni

That mean IterNo() is used to populate the missin dates ? whcy is there -1 in it ?

And is this the only way to generate the missing dates or can we have master calender script intead ?

What do you suggest whcy is reliable ?

Yes there is a table called "Event_TAble" which has many fields including "Date field (01-16-2020 00:00:00)"

Thanks

Re: Explain

marcus_sommer — Thu, 04 Jun 2020 09:25:41 GMT

Iterno() starts with 1. If your min-date starts with 01/01/2020 and you adds 1 then would your calendar start with 01/02/2020 - means the 01/01/2020 would be missing. Therefore -1 to include the min-date.

- Marcus

Re: Explain

Anil_Babu_Samineni — Thu, 04 Jun 2020 09:47:56 GMT

Yes, Iterno() can prevent the data as per records missing - I would love to have master calendar instead?