Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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:
I think it is a problem with the number format.