Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Peek

Hi All,

What is wrong with the following script. (no syntax error, but garbage error):

Let vDiagnosisCrit = NoOfRows('DiagnosisCrit');
Let vConditions = '';

for i=0 to $(vDiagnosisCrit)
let vConditions = '$(vConditions), ' & peek('DiagnosisCrit_Condition',$(i),'DiagnosisCrit');

next  

3 Replies
oknotsen
Master III
Master III

No clue on a first glance.

What I suggest is that you add a bunch of TRACE statements to that loop to figure out what the individual variables are on any given moment.

TRACE Loop number $(i);

TRAVE vDiagnosisCrit = $(vDiagnosisCrit )

etc...

May you live in interesting times!
Kushal_Chawda

What you are trying to achieve?

marcus_sommer

Maybe it's your start with a comma. Instead of:

let vConditions = '$(vConditions), ' & peek('DiagnosisCrit_Condition',$(i),'DiagnosisCrit');

try

let vConditions = '$(vConditions)' & peek('DiagnosisCrit_Condition',$(i),'DiagnosisCrit') & ', ';

- Marcus