Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am new to Qlikview
What is Peek Function give me an example
plz help.
Hi,
You can use it to create running totals in script, so for example the following;
Comes from the toy script;
data:
load * inline [
Year, Month, Sales, Production
2016, Jan, 1000, 1500
2016, Feb, 800, 1300
2016, Mar, 600, 1400
2016, Apr, 900, 1500
2016, May, 500, 1400
];
data_final:
NoConcatenate
LOAD
RowNo() as row_no,
If(RowNo()=1,0,peek('Stock_Open')+Previous(Production)-Previous(Sales)) AS Stock_Open,
*
Resident data;
drop table data;
Cheers,
Chris.
Hi,
You can use it to create running totals in script, so for example the following;
Comes from the toy script;
data:
load * inline [
Year, Month, Sales, Production
2016, Jan, 1000, 1500
2016, Feb, 800, 1300
2016, Mar, 600, 1400
2016, Apr, 900, 1500
2016, May, 500, 1400
];
data_final:
NoConcatenate
LOAD
RowNo() as row_no,
If(RowNo()=1,0,peek('Stock_Open')+Previous(Production)-Previous(Sales)) AS Stock_Open,
*
Resident data;
drop table data;
Cheers,
Chris.
The PEEK function is used to fetch the data present in any table available in your data model if you specify the table name and the number where the data is present.
If you did not specify any table name by default peek function will gives the previous row value as a result.
Kindly refer this help link which contains brief explanation and example https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...