Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Didn't find field...

Hello QVers,

I'm trying the script:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
let
vMINDATUM=num(peek('Bestelldatum', 0,'Bestellungen'))
;

let
vMAXDATUM=num(peek('Bestelldatum', -1,'Bestellungen'))
;

DATUMSFELD:
load
date($(vMINDATUM)+iterno()-1) as DATUMSFELD
autogenerate (1)
while $(vMINDATUM)+IterNo()-1<=$(vMAXDATUM)
;
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

I always got the error:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Didn't find field - <<=>
Datumsfeld:
...
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Can anyone see what's wrong? Because the scipt is from QV-Developer course.

Thank You. I'm using QV=9.00.7440.8 SR3

dj_skbs



1 Solution

Accepted Solutions
Not applicable
Author

Hi,

your tablename "Bestellungen" is miss-spelled. It should be "BESTELLUNGEN_z". Don't forget the case sensitivity! The peek-statement returns no error if it can't find the tablename (or fieldname!). This is ugly but real.

use trace to see what is in a variable


trace varMinDatum --$(varMinDatum)--;
trace varMaxDatum --$(varMaxDatum)--;


Good luck and Enjoy QV

Roland

View solution in original post

5 Replies
llauses243
Creator III
Creator III

Hi,

vMAXDATUM is NULL ¡? please verify

good luck

/Luis.

Not applicable
Author

Hi,

you can use the trace - command to see what is in your variable(s). Some seem to be null.

Regards, Roland

Not applicable
Author

Hi,
yes, you all are right and I also got the info that there must be something NULL with the variable.
May be I don't see the wood for the trees, I'm racking my brains or anything else > I can't find out
the problem.
So I will send You my opus in a zip file containing qv and sources from qv-course and I want to rebuild that.

Please see attached. Thank You.
dj_skbs

Not applicable
Author

Hi,

your tablename "Bestellungen" is miss-spelled. It should be "BESTELLUNGEN_z". Don't forget the case sensitivity! The peek-statement returns no error if it can't find the tablename (or fieldname!). This is ugly but real.

use trace to see what is in a variable


trace varMinDatum --$(varMinDatum)--;
trace varMaxDatum --$(varMaxDatum)--;


Good luck and Enjoy QV

Roland

Not applicable
Author

Hi, that's it. Thank You Roland and the others. dj_skbs