Discussion Board for collaboration related to QlikView App Development.
I'm trying to read a public database of invoicing per companies, and some of them doesn't have a numeric value, instead of this, there's a word "big" which means they have big invoicing.
In order to analyze this, I'd like to read all the rows and if a rows contains a non numeric value, read the previous numeric value it was found.
Easy example :
And I'd like to get :
How can I get this?
Load * Inline
If(trim(Billing)='Big', Peek('NewValue'), Billing) as NewValue
drop table DataTmp;
View solution in original post
Nagesh you can also use this If condition in your Inline Load too like
Load *, If(trim(Billing)='Big', Peek('NewBilling'), Billing) as NewBilling
Peek function would resolve your scenario
peek( 'field', 0, 'Tab1' )
It gives based on your optional parameter to get the previous record to read which is equivalent to previous(field).
Thanks guys! Thay was it. Thanks for all your suggestions.