Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
He All,
What is peek function and how to use it any one help with any example.
Thanks
hi RitulRaj,
peek is QlikView function it
Returns the contents of the fieldname in the record specified by row in the internal table tablename.
Syntax : peek(Fieldname [ , Row [ , TableName ] ] )
for more info please explore community or QlikView help
Regards
I used peek recently to accumulate by customer by AR invoice (and AR receipts) as follows on this thread (it is the only way I could find to do this).
http://community.qlik.com/message/272221#272221
The issue was to match customer AR invoices with AR receipts on a first in first out basis
Data:
load * Inline [
rowId, trnNo, trnDate, custId, trnType, trnAmount, trnAmt, trnDrAmt, trnCrAmt
1, BNK-1, 01/05/2011, a1, Cr, 31000, 31000, 0, 31000
2, INV-1, 05/05/2011, a1, Dr, 45000,-45000,45000, 0
3, BNK-2, 05/05/2011, a1, Cr, 15000, 15000,0, 15000
4, INV-2, 06/05/2011, a2, Dr, 40000,-40000,40000, 0
5, INV-3, 07/05/2011, a1, Dr, 12000, -12000,12000,0
6, INV-4, 08/05/2011, a1, Dr, 35000,-35000,35000, 0
7, BNK-3, 09/05/2011, a1, Cr, 45000, 45000,0, 45000
8, BNK-4, 20/05/2011, a2, Cr, 20000, 20000,0, 20000
9, BNK-5, 20/06/2011, a2, Cr, 21000, 21000,0, 21000
10, BNK-6, 28/06/2011, a2, Cr, 11000, 11000,0, 11000
];
// load invoices
DataInv:
LOAD
rowId,
trnNo,
trnDate,
custId,
trnType,
trnAmount,
trnAmt,
trnDrAmt,
IF(PREVIOUS(custId)=custId,
PEEK('AccInv'),0)+trnAmount AS AccInv,
trnCrAmt
resident Data
where trnType = 'Dr'
order by trnType,custId,trnNo,rowId