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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using the function peek

Hello everyone,

I am new on QlikView and i´m trying to peek the 3rd value from a field using the function peek.

Below is the field that i am trying to peek the 3rd value:

peek.JPG


The name of the table is 'TreinamentosSP', sou i did that in the script:

varParticipacao = peek('[% de Participação]', 3, 'TreinamentosSP');
Participacao:
LOAD $(varParticipacao) as Participacao
FROM TreinamentosSP;

When i run the script, i receive error msg from QlikView.

Somebody can help me to understand what it is wrong?

Thanks in advance,

Rodrigo

Labels (1)
10 Replies
Not applicable
Author

When i removed the [..] from the field name literal, the script finish with no errors, otherwise it returne "####" in the variable result, as you can see below:

2015-10-01_15-28-22.jpg

2015-10-01_15-30-01.jpg

I think it is a problem with the number format.