topic Issue Loading in TempCalendar in QlikView

Issue Loading in TempCalendar

Wed, 25 Nov 2020 16:16:04 GMT

Dear QVExperts,

I am facing an issue.

LET varMinDate = '09/01/2008';

LET varMaxDate = '05/31/2013';

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

If execute this script, the dates should be loaded till 31st May 2013.

But it loads only till 28th May 2011.

It is surprising. Can you please suggest me.

Thanks

Sasi

Re: Issue Loading in TempCalendar

Fri, 20 May 2016 15:26:27 GMT

Even i try this,

LET varMinDate = '09/01/2008';

LET varMaxDate = '05/31/2013';

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

//While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

While IterNo() <= '$(varMaxDate)' - '$(varMinDate)' +1;

But inserted till 28th May 2011.

Thanks,

Sasikumar

Re: Issue Loading in TempCalendar

tamilarasu — Fri, 20 May 2016 15:28:20 GMT

Sasi,

Try this,

LET varMinDate = Num(Date#('09/01/2008','MM/DD/YYYY'));

LET varMaxDate = Num(Date#('05/31/2013','MM/DD/YYYY'));

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

Re: Issue Loading in TempCalendar

Kushal_Chawda — Fri, 20 May 2016 15:30:57 GMT

You need to use Date# to recognize the variable value as numerical

LET varMinDate = floor(date#('09/01/2008','MM/DD/YYYY'));

LET varMaxDate = floor(date#('05/31/2013','MM/DD/YYYY'));

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

Re: Issue Loading in TempCalendar

Fri, 20 May 2016 15:31:42 GMT

Hello Tamil,

THanks.

Still the same.

Please find enclosed the screenshot.

Re: Issue Loading in TempCalendar

Fri, 20 May 2016 15:33:02 GMT

Thanks Kush. Still the same. It loads till 28th May 2011.

Sasi

Re: Issue Loading in TempCalendar

Kushal_Chawda — Fri, 20 May 2016 15:35:16 GMT

see may attached app

Re: Issue Loading in TempCalendar

Anonymous — Fri, 20 May 2016 15:37:55 GMT

Hi Sasi ,

Your script is working fine for me .

LET varMinDate = date#('01/09/2008','MM/DD/YYYY');

LET varMaxDate = Date#('05/31/2013','MM/DD/YYYY');

//DROP Table Temp;

TempCalendar:

LOAD

Date('$(varMinDate)' + IterNo() - 1) as TempDate

AutoGenerate 1

While '$(varMinDate)' + IterNo() -1 <= '$(varMaxDate)';

Re: Issue Loading in TempCalendar

tamilarasu — Fri, 20 May 2016 15:39:32 GMT

Sasi,

It's working fine. Check the attachment.

Re: Issue Loading in TempCalendar

rwunderlich — Fri, 20 May 2016 15:39:52 GMT

Please post the Document Log so we may see what your script is doing.

-Rob

Re: Issue Loading in TempCalendar

Fri, 20 May 2016 16:52:32 GMT

Thanks All.

If i populate in ListBox, it is showing. But when you view in TableViewer, it is showing only till 28/05/2011.

Are there any specific reason for it.

Thanks,
Sasi

Re: Issue Loading in TempCalendar

Anonymous — Fri, 20 May 2016 17:17:53 GMT

Hi Sasi,

In Table Viewer it will show some sample values in preview not all records.

Hope it helps!!

Re: Issue Loading in TempCalendar

Kushal_Chawda — Fri, 20 May 2016 17:22:28 GMT

Tableviwer will not display full data, it picks certain rows of data