How do I remove restrictions on the number of rows returned?

[#1]

It seems that not all of my records are returned. I've been modifying my Load Query so I don't think there is a problem there and my only explanation is that QlikView stops returning records when it reaches a limit. Is this a restriction on the trial version?

[#2]

Hello,

there is no limit in your trail version (personal edition) concerning the loadprocess. You should be able to load as much tables,fields and of course rows as you can. The limit is your hardware (RAM!) as QV loads all the data into memory. If your hardware has not enough memory an error message will appear but this does NOT depend on a version.

So please be more exactly what error or message you got. Or tell us your suspicion.

Regards, Roland

[#3]

There is no such restriction on trial version. May be joins created on unique key combination are suppressing the number of records.

[#4]

Ok, that's good to know. It now looks like it has to do with how I implemented the calandar code presented in the dev training. My Qtr, Month, and Year fields don't always populate properly. I'll see if I can isolate the problem a bit more. Thanks.

[#5]

I figured it out. The code below is from the example in the Dev Training except I used ACCESSIONDATE from CaseTable to select the date range and tied the TempDate to ACCESSIONDATE. Although in the original example it dropped the temp table I found that it only worked correctly by not dropping it. I'm not sure I understand why though.

----------------------------------------------------------------------------------------------------------------------------------

LET varMinDate = Num(Peek ('ACCESSIONDATE',0,'CaseTable'));
LET varMaxDate = Num(Peek('ACCESSIONDATE',-1,'CaseTable'));
LET varToday = Num(Today());

//************TempCalendar***********
TempCalendar:
LOAD
$(varMinDate) + rowno() - 1 AS DateNumber,
date ($(varMinDate) + rowno() - 1) AS TempDate
AUTOGENERATE
$(varMaxDate) - $(varMinDate) + 1;

//*************Master Calendar************
MasterCalendar:
LOAD
TempDate AS ACCESSIONDATE,
Week (TempDate) AS Week,
Year (TempDate) AS Year,
Month (TempDate) AS Month,
Day (TempDate) AS Day,
Weekday (TempDate) AS WeekDay,
'Q' & Ceil(Month (TempDate)/3) AS Quarter,
Date( Monthstart (TempDate), 'MMM-YYYY') AS MonthYear,
Week (TempDate) & '-' & Year (TempDate) AS WeekYear,
Inyeartodate(TempDate, $(varToday), 0)*-1 AS CurYTDFlag,
Inyeartodate (TempDate, $(varToday), -1)*-1 AS LastYTDFlag
Resident TempCalendar
Order by TempDate ASC;

//Drop Table TempCalendar;

[#6]

oops. Wait, I think the real reason is because when I reload I need to reload all tabs in the script. I didn't realize that it do this automatically.

[Miguel_Angel_Baeyens · Accepted solution]

Hello Chad,

In order to get the minimum and maximum values right, are you loading CaseTable date ordered? If so, then you should get all possible dates between your minimum and maximum ACCESSIONDATE even if there are no cases for that date. If not, then you should order that table (or create a new one loading resident, ordered ascending), so the first record is always the actual minimum date and the last one is the maximum, and the temp table must be dropped.

Hope this helps