peek function

[qlikpms]

hi everybody,

i need your help please

i wrote in my script :

if(InterventionDate=peek('InterventionDate'),
num('0,'&subfield(num(peek('InterventionHeureDebut',RowNo()+1)),',',-1))*1440) as NumHeureDebut,

and the result is  (column i have in red)

in yellow what i wish

in the first line i d like to have the result of interventionHeure in the second line, etc...

Many thanks for your help

Best

C.

[stevejoyce]

remove quotes in peek function parameter and see if that solves your problem

it should be peek(InterventionDate)