topic Re: Script Line Error in QlikView

Script Line Error

Anonymous — Fri, 30 Jan 2015 13:35:59 GMT

Hi All,

I am getting a script line error while using Peek function to create a variable :

LET vCount3

= Peek('MyField', $(vCount2),'Test1');

Where

LET vCount2 = '$(vCount1)/2';
LET vCount1 = 'Count(Distinct MyField)';

Thanks!

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 13:38:32 GMT

Hi,

Please copy paste whole script , so can help

Regards

Neetha

Re: Script Line Error

alexandros17 — Fri, 30 Jan 2015 13:39:30 GMT

Right side of let instruction without apex

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 13:42:26 GMT

Hi Neetha,

Thanks for your reply.

The script is nothing much. A straight forward load statement to load few fields from a qvd and then I am tring to create these variables.

First 2 variables are created correctly, its just when I am trying to create the third variable i.e. vCount3, it throws a script line error.

I have tried using 'Fieldvalue' function instead of peek as well. But same error. 😞

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 13:44:10 GMT

Hi Alessandro,

Do you mean ' ' by apex?

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 13:55:24 GMT

Okay, so i haved added ' ' , now there is no error but it returns an empty vCount3, so the variable expression now looks like:

LET vCount3 = Peek ('MyField', '$(vCount2)', Test1');

but returns an empty value. Any clues?

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 14:07:19 GMT

Hi,

please check value in variable vCount2 using textbox in ui.

and check if value for previous row in table is not null.

see how many records are in table.

Re: Script Line Error

Anonymous — Fri, 30 Jan 2015 14:10:58 GMT

Hi Neetha,

vCount1 and vCount2 both give correct results.

And none of the row is null.

Re: Script Line Error

alexandros17 — Fri, 30 Jan 2015 15:04:40 GMT

LET vCount2 = $(vCount1)/2;
LET vCount1 = Count(Distinct MyField);

Re: Script Line Error

Colin-Albert — Fri, 30 Jan 2015 15:10:08 GMT

what is the value of vCount2? It must be an integer for PEEK.

You can test your peek command using

LET vCountTest = Peek('MyField', 1, 'Test1');

Re: Script Line Error

maxgro — Fri, 30 Jan 2015 21:11:01 GMT

I think Albert is correct, vCount1 is wrong and so you don't get an integer in vCount2 and Peek doesn't work

Re: Script Line Error

Sat, 31 Jan 2015 09:18:22 GMT

Variable vCount1 is used (in vCount2) before it is assigned a value.

Also, although vCount1 contains a 'string', its value when evaluated in vCount2 will return a null, since a field value count cannot be computed like the way it is done.