topic Where is the error? in QlikView

Where is the error?

Fri, 11 Feb 2011 09:55:59 GMT

Hi,

Where is the error?

I want to take a record in a table

let

cont=0;

For

i=0 to '$(numrighe)'

let cont=cont+1;

Thanks a lot

( startDate > peek('Invoice Date',$(i),'SALESDETAILS'))

Where is the error?

gauravkhare — Fri, 11 Feb 2011 10:19:52 GMT

hi,

can you please be more precise with your query...i mean kindly revert back with what you require...as per your post this scripting looks quite fine to me. after you write this code and press check what is the error it's showing up?

if possible kindly send a screen shot with your requirment.

Where is the error?

Fri, 11 Feb 2011 10:38:36 GMT

There is an error in the line of if()....

Thanks

Where is the error?

Fri, 11 Feb 2011 11:02:56 GMT

Hi,

I think u miss then in the If statement, try below statement

if(startDate > peek('Invoice Date',$(i)),'SALESDETAILS')