topic Re: Peek in QlikView

Peek

Anonymous — Fri, 22 Apr 2016 14:29:19 GMT

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

Re: Peek

oknotsen — Fri, 22 Apr 2016 14:34:10 GMT

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...

Re: Peek

Kushal_Chawda — Fri, 22 Apr 2016 14:36:15 GMT

What you are trying to achieve?

Re: Peek

marcus_sommer — Fri, 22 Apr 2016 14:46:50 GMT

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