Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jonesbrown
Creator
Creator

What is  Peek  Function give me an example

Hi All

I am new to Qlikview

What is  Peek  Function give me an example 

plz help.

Labels (1)
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

You can use it to create running totals in script, so for example the following;

20191123_3.png

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.

View solution in original post

2 Replies
chrismarlow
Specialist II
Specialist II

Hi,

You can use it to create running totals in script, so for example the following;

20191123_3.png

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.

vijayaganesh_s
Partner - Contributor III
Partner - Contributor III

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...