Peek or Previous for previous record -issue

Fri, 26 Aug 2011 00:27:36 GMT

I am getting 2 different source and get the price for missing period also based on previous record.

Please check the attached file

expecting results like

If it is one SSUMatKey

(IsNum(MovingPrice)=0,peek(Newvalue),MovingPrice) as Newvalue is working fine.

Advance thanks for your help.

Fri, 26 Aug 2011 03:08:55 GMT

both works almost same but with peek() we can find the value of 1st row element which we'll get null with previous .

hope this helps.

thanks

Meher

topic Peek or Previous for previous record -issue in QlikView