topic Re: query on peek function in QlikView

query on peek function

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am facing some issue in the below load script:

test:

load *,

NoOfRows('TESTMain') as CountNO

Resident TESTMain;

Drop Table TESTMain;

Let vTest = peek('CountNO',0,'test')

if($(vCount)>0) Then

EXIT Script

Endif

I am getting script line error message in below lines

(if(>0) Then) ,

endif.

I am checking for null condition but not sure why the variable vTest does not returns any value.

Thanks in advance!!

Rohit

Re: query on peek function

swuehl — Wed, 19 Apr 2017 12:58:17 GMT

Maybe just use the variable vTest instead of vCount?

IF vTest >0 THEN

Re: query on peek function

Wed, 19 Apr 2017 13:48:50 GMT

Hi Stefan,

It was a typo. I use the same but it not giving any value. It gives error message as stated in my earlier note.

Thanks,

Rohit

Re: query on peek function

swuehl — Wed, 19 Apr 2017 13:55:12 GMT

Please post the exact script snippet content. There is easily a semicolon missing if you type it manually, e.g. after exit script:

Exit script;

In total, I think you just need

IF NoOfRows('TESTMain') >0 THEN

Exit script;

END IF

Re: query on peek function

aarkay29 — Wed, 19 Apr 2017 14:02:01 GMT

seems like you are missing semicolon

Let vTest = peek('CountNO',0,'test') ;

Re: query on peek function

Wed, 19 Apr 2017 14:21:22 GMT

Hi,

I am redefine my load script but it is giving me error in IF condition i.e. if($(vTest)>0) .

test:

load *,

NoOfRows('TESTMain') as CountNO

Resident TESTMain;

Drop Table TESTMain;

Let vTest = peek('CountNO',0,'test')

if($(vTest)>0) Then

EXIT Script

endif

Thanks,

Rohit

Re: query on peek function

swuehl — Wed, 19 Apr 2017 14:25:13 GMT

Have you checked the variable content in script debugger or with a TRACE?

Note that you don't need dollar sign expansion in the IF statement:

IF vTEST > 0 THEN

Exit script; // don't forget the semicolon...

END IF // I believe it's written that way

Re: query on peek function

klausskalts — Wed, 19 Apr 2017 14:28:35 GMT

I normally use the NoOfRows() function to get the number of rows in a table directly.

Let vNoOfRows = NoOfRows('SalesTable');
Let vNoOfQVDRows = QvdNoOfRecords('QVD_SalesTable.qvd');

It's faster to execute and easier to maintain.

Re: query on peek function

aarkay29 — Wed, 19 Apr 2017 14:30:40 GMT

PFA

seems to be working without an error

Re: query on peek function

Wed, 19 Apr 2017 14:48:32 GMT

Thanks Stefan.

Condition work fine.

Just one more thing does variable vTEST return NULL or give some numeric data.

Thanks,

Rohit

Re: query on peek function

swuehl — Wed, 19 Apr 2017 14:54:06 GMT

Just one more thing does variable vTEST return NULL or give some numeric data.

Is this a question? Well, it depends how you define the variable...