topic conditional load first 100 records for debugging in QlikView

conditional load first 100 records for debugging

andries_bos — Thu, 01 Mar 2012 13:20:32 GMT

I did find the discussion at http://community.qlik.com/message/70809#70809 but this will fail to work for me : My code is reading through odbc:

MyTable:

First 100

Load

field1,

field2;

Sql SELECT *

FROM "My_Table"

where "My_Table".code = 'abc'

Although the 'first' statement is set to 100 it still (I presume through the sql statement) loads all 4milj records.

What would be the best solution to be able to set a global variable 'debugging' to e.g. true or false (or a number) : depending on this variable the load shouls only be perfomed on the first 100 records.

Any best practive examples are welcome.

P.s. I did notice the debudding 'limited load' option : this seems to work and helps a lot; however using the debugger is slower that a normale reload.

conditional load first 100 records for debudding

CELAMBARASAN — Thu, 01 Mar 2012 13:26:25 GMT

Try this

Sql SELECT TOP 100 *

FROM "My_Table"

where "My_Table".code = 'abc'

Hope it helps

Celambarasan

conditional load first 100 records for debudding

andries_bos — Thu, 01 Mar 2012 14:35:27 GMT

with Celambarasan Adhimulam answer, I changed my code to :

Let vMaxRecords = 100;

and changed my script to :

Sql SELECT TOP $(vMaxRecords) *

FROM "My_Table"

where "My_Table".code = 'abc'

this seems to work !