topic Next Item Data is not loading based on Item in QlikView

Next Item Data is not loading based on Item

Wed, 15 Apr 2015 05:49:26 GMT

I have table data like the below,

Item_ID Date Price

PR01 01-Jan-2014 40

PR01 03-Jan-2014 NULL

PR01 04-Jan-2014 30

PR01 05-Jan-2014 NULL

PR02 01-Jan-2014 NULL

PR02 02-Jan-2014 50

PR02 03-Jan-2014 NULL

PR02 04-Jan-2014 40

And I want the result the data like below,

Item_ID Date Price

PR01 01-Jan-2014 40

PR01 03-Jan-2014 40

PR01 04-Jan-2014 30

PR01 05-Jan-2014 30

PR02 01-Jan-2014 50

PR02 02-Jan-2014 50

PR02 03-Jan-2014 40

PR02 04-Jan-2014 40

I tried the some option but it is not working as expected .Please anyone sugggest

If(Len(Trim(Price))=0 and Item_ID=Previous(Item_ID), Peek( Price),Price),

Ralf-Narfeldt — Wed, 15 Apr 2015 08:55:19 GMT

Have you tried substituting Len(Trim(Price))=0 with IsNull(Price)?

Wed, 15 Apr 2015 09:18:59 GMT

Ya It is working fine

Ralf-Narfeldt — Wed, 15 Apr 2015 09:24:30 GMT

Great! Please mark the question as Answered if you're happy!

Wed, 15 Apr 2015 09:27:51 GMT

Hi Ganesh,

If(Isnum(Price)=0 And Item_ID=Peek('Item_ID',-1), Peek('Price',-1),Price)

should work for you as you are expecting a valid number in your price field.

hope that help
Joe