topic Re: 'Peek' function in Qlikview in QlikView

'Peek' function in Qlikview

susovan — Thu, 07 Jan 2016 11:51:32 GMT

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

Re: 'Peek' function in Qlikview

marcus_sommer — Thu, 07 Jan 2016 12:07:00 GMT

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

Re: 'Peek' function in Qlikview

susovan — Thu, 07 Jan 2016 12:45:12 GMT

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

Re: 'Peek' function in Qlikview

marcus_sommer — Thu, 07 Jan 2016 13:02:50 GMT

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

- Marcus

Re: 'Peek' function in Qlikview

Thu, 07 Jan 2016 19:16:07 GMT

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

Re: 'Peek' function in Qlikview

Anonymous — Thu, 07 Jan 2016 19:33:47 GMT

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.

Re: 'Peek' function in Qlikview

engishfaque — Fri, 08 Jan 2016 04:37:17 GMT

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

Re: 'Peek' function in Qlikview

rajeshforqlikvi — Fri, 08 Jan 2016 04:53:23 GMT

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

Re: 'Peek' function in Qlikview

PradeepReddy — Fri, 08 Jan 2016 05:17:21 GMT

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

Re: 'Peek' function in Qlikview

susovan — Fri, 08 Jan 2016 05:28:25 GMT

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

Re: 'Peek' function in Qlikview

jagan — Fri, 08 Jan 2016 07:19:52 GMT

Hi,

You can refer for detailed explanation in Qlikview Help file (F1) for Peek(), FieldValue(), LookUp() and Previous().

Regards,

Jagan.

Re: 'Peek' function in Qlikview

Karim_Khan — Fri, 08 Jan 2016 07:23:13 GMT

Hi Susovan,

Yes you can use Peek() function in script level to get the specific value from the table

Re: 'Peek' function in Qlikview

susovan — Fri, 08 Jan 2016 10:00:50 GMT

Thanks to karim,

Its properly works.

Re: 'Peek' function in Qlikview

jagan — Mon, 11 Jan 2016 00:24:01 GMT

Peek() is a script function, it won't work in Charts, for this you can use Above() . If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

Jagan.

Re: 'Peek' function in Qlikview

manojkulkarni — Mon, 11 Jan 2016 04:30:33 GMT

check the link

Peek() vs Previous() – When to Use Each

Re: 'Peek' function in Qlikview

sujeetsingh — Mon, 11 Jan 2016 04:37:09 GMT

I think this thread should be marked answered now!

Re: 'Peek' function in Qlikview

Karim_Khan — Mon, 11 Jan 2016 08:36:26 GMT

Yes it will help other to get the answer quickly