Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

niceqlik
New Contributor III

Limited load check IsLimitedLoad() ?

Hi Guys,

I'm wondering if we can check the current reload is limited load in script pane when we execute a limited load?

After i pull data from db, i store my table into a qvd, but i want to prevent storing qvd process when i execute a limited load?

I need a statement like IsLimitedLoad() .

Is there a way that you may suggest?

Thanks.

Tags (2)
1 Solution

Accepted Solutions
niceqlik
New Contributor III

Limited load check IsLimitedLoad() ?

I found a way by myself utilizing a dummy table which has 1000 rows of autogenerated numbers.

Before storing tables into qvds, i check the size of this table using a simple if-then-else statement. if the size is equal to or below 10, i do not let STORE commands execute. Since this dummy table is also affected and narrowed down in row count during a limited load, this would help me a lot. Of course loading more than 10 records will not be considered as a limited load in this script but we mostly use 10 records as default.

ROWCOUNT: load iterno() as row autogenerate(1) while iterno() <=1000;

if NoOfRows('ROWCOUNT')>10 then

STORE Table1 INTO Table1.Qvd;

End if

Drop table ROWCOUNT;

1 Reply
niceqlik
New Contributor III

Limited load check IsLimitedLoad() ?

I found a way by myself utilizing a dummy table which has 1000 rows of autogenerated numbers.

Before storing tables into qvds, i check the size of this table using a simple if-then-else statement. if the size is equal to or below 10, i do not let STORE commands execute. Since this dummy table is also affected and narrowed down in row count during a limited load, this would help me a lot. Of course loading more than 10 records will not be considered as a limited load in this script but we mostly use 10 records as default.

ROWCOUNT: load iterno() as row autogenerate(1) while iterno() <=1000;

if NoOfRows('ROWCOUNT')>10 then

STORE Table1 INTO Table1.Qvd;

End if

Drop table ROWCOUNT;