'Peek' function in Qlikview

[susovan]

Is this possible to use the 'peek' function in qlikview application?

[marcus_sommer]

Here is a very good explanation: Peek() or Previous() ?

Edit: Or do you mean within the gui? There is no peek available but with pick(match()), fieldvalue(fieldindex()) or an only() with set analysis could be used to get the data which you want.

- Marcus

[susovan]

Is this possible to get the value of particular column through this function?

[marcus_sommer]

I assume yes - but you need to be more specific, what do you want to do?

- Marcus

[#5]

Hi Susovan. The answer is 'Yes'. You can get the value of particular column and register through this function.

How?

peek ( 'columnName' , rowNumber , 'tableName' )

replace columnName for the name of your column/field

replace rowNumber for the number of your row

replace tableName for the name of your table

I hope that it help you!

Regards

Agustin

[Anonymous]

If you are referring to front end dashboard expression functions then look at the Chart Inter Record Functions like  :

• above()
• below()
• before()
• after()

The peek() function can only be used in the load script.

[engishfaque]

Dear Susovan,

Yes it is possible to use Peek() function in QlikView,

Peek() Function:

Returns the contents of the fieldname in the record specified by row in the internal table tablename.

Syntax

Peek(fieldname [ , row [ , tablename ] ] )

Examples:

peek( 'Sales' )

returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).

peek( 'Sales', 2 )

returns the value of Sales from the third record read from the current internal table.

peek( 'Sales', -2 )

returns the value of Sales from the second last record read into the current internal table.

peek( 'Sales', 0, 'Tab1' )

returns the value of Sales from the first record read into the input table labeled Tab1.

Kind regards,

Ishfaque Ahmed

[rajeshforqlikvi]

Hi This is very much possible to use in the QlikView application in the script level.

Peek function is used for holding the row value of a particular column.

more more details go in the QlikView help  -> index  and type hare peek and inter the enter key you will get all syntax with details examples..

[PradeepReddy]

peek () - can be used at script level only, to get the specific record's cell value

[susovan]

But 'Peek' function its not working in our Qlikview Application.