topic Re: Peek Function in QlikView

Peek Function

Thu, 22 Jan 2015 10:59:25 GMT

I have a table as follows:

Particulars	Qty	Unit Rate	Amount
item A	1	25	0
production	1	25	0
item B	20	25	0
production	1	25	0
item C	5	25	125
item D	10	25	250
item E	10	25	250
item F	10	25	0
production	1	25	0
item G	20	25	500

The logic is as follows:

if the word production appear the row that row and the row above should not be calculated. can anyone tell how to solve this using peek or previous function.

will be great if i get results in Qlikview

Re: Peek Function

marcus_sommer — Thu, 22 Jan 2015 11:18:35 GMT

Maybe this is helpful: http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/08/peek-vs-previous-when-to-use-each

- Marcus

Re: Peek Function

Gysbert_Wassenaar — Thu, 22 Jan 2015 11:19:34 GMT

See attached qvw.

Re: Peek Function

alexandros17 — Thu, 22 Jan 2015 11:21:53 GMT

try with this code

AAA:
load * inline [
Particulars, Qty, Unit, Rate, Amount
item, A, 1, 25, 0
production, ,1, 25, 0
item, B, 20, 25, 0
production,, 1, 25, 0
item, C, 5, 25, 125
item, D, 10, 25, 250
item, E, 10, 25, 250
item, F, 10, 25, 0
production,, 1, 25, 0
item, G, 20, 25, 500
];

BBB:
NoConcatenate
LOAD RowNo() as nriga, *, If(Particulars='production',1,0) as flag Resident AAA;
DROP Table AAA;

CCC: NoConcatenate
LOAD nriga as toDel Resident BBB Where flag=1;
Concatenate
LOAD Previous(nriga) as toDel Resident BBB Where flag=1;

TEMP: NoConcatenate
LOAD * Resident BBB;
Left Join
LOAD toDel as nriga, 1 as NewFlag Resident CCC;
DROP Tables BBB, CCC;

Final: NoConcatenate
LOAD * Resident TEMP Where NewFlag <> 1;
DROP Table TEMP;

Re: Peek Function

MarcoWedel — Thu, 22 Jan 2015 13:35:27 GMT

table1:
LOAD Particulars, 
     Qty, 
     [Unit Rate],
     RecNo() as LoadOrder
FROM [http://community.qlik.com/thread/149240] (html, codepage is 1252, embedded labels, table is @1);

Left Join (table1)
LOAD LoadOrder,
     If(Match('production',Particulars,Previous(Particulars)),0,Qty*[Unit Rate]) as Amount
Resident table1
Order By LoadOrder desc;

Re: Peek Function

MarcoWedel — Fri, 23 Jan 2015 00:38:24 GMT

hope this helps

regards

Marco