topic Re: can any one explain this function? in QlikView

can any one explain this function?

Mon, 25 May 2015 10:25:10 GMT

hi,

I want create master calender in qlikview .I write function like this letvmindate=num(peek('orderdate',0,'produt'))

letvmaxdate=num(peek('orderdate',-1,'product'))

and I do not understand below this function.pls can anyone explain below function

date($(varMinDate) + rowno() – 1) As TempDate

Autogenerate

$(varMaxDate) – $(varMinDate) + 1;

Thankyou,

Regards

madhu

Re: can any one explain this function?

MayilVahanan — Mon, 25 May 2015 10:38:17 GMT

date($(varMinDate) + rowno() – 1) As TempDate

Autogenerate

$(varMaxDate) – $(varMinDate) + 1;

It generate the dates from Min Date to Max Date.

Re: can any one explain this function?

Mon, 25 May 2015 10:53:54 GMT

Hi,

date($(varMinDate) + rowno() – 1) As TempDate

Autogenerate

$(varMaxDate) – $(varMinDate) + 1;

TempDate column will create a sequence dates from minimum date i.e(varMinDate) to maximum date i.e(varMaxDate).

Ex : Consider varMinDate 1021 (i.e 21May2015) and varMaxDate 1030 i.e(30May2015), now the above code looks like below :

firstloop:

date(1021 + 1 - 1) as TempDate

Autogenerate

1030 - 1021 +1;

Output for TempDate = 21May2015

secondloop:

date(1021 + 2 - 1) as TempDate

Autogenerate

1030 - 1021 +1;

Output for TempDate = 22May2015

...

Tenthloop:

date(1021 + 10 - 1) as TempDate

Autogenerate

1030 - 1021 +1;

Output for TempDate = 30May2015

1030 - 1021 +1 = 10, so the loop runs only for 10 times

I hope this example gives you some idea.

Regards,

Satish.

Re: can any one explain this function?

Tue, 26 May 2015 04:27:28 GMT

thankyou satish.i understand but date(1021 + 1 - 1) as TempDate.in this example. the 1021 adds +1=1022 -1=1021 is this process.or what is +1 and -1 explain pls satish.

regards

madhu

Re: can any one explain this function?

sujeetsingh — Tue, 26 May 2015 04:47:06 GMT

+1 is the increment in the value and -1 is the deduction. Hence the +1 is adding one day to the min date here.