topic Re: What is Peek Function give me an example in QlikView

What is Peek Function give me an example

jonesbrown — Sat, 16 Nov 2024 19:37:02 GMT

Hi All

I am new to Qlikview

What is Peek Function give me an example

plz help.

Re: What is Peek Function give me an example

chrismarlow — Sat, 23 Nov 2019 16:53:46 GMT

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.

Re: What is Peek Function give me an example

vijayaganesh_s — Sun, 24 Nov 2019 02:38:19 GMT

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/InterRecordFunctions/Peek.htm