topic Peek Issue in QlikView

Peek Issue

dineshm030 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Legends,

Peek function is not working in Resident table.

Below is screenshot for your reference.

Thanks in advance.

MK_QSL — Mon, 12 Mar 2018 08:11:07 GMT

Try

Peek('SV1') as Peek1

Peek('Peek1') as Peek1

Also don't forget to use correct Order By syntax.

sasiparupudi1 — Mon, 12 Mar 2018 08:11:26 GMT

Peek('Sales Volume') as Peek1

Use Orderby Month clause.. hth

the peek takes a string input

sasiparupudi1 — Mon, 12 Mar 2018 08:16:06 GMT

field_name

Name of the field for which the return value is required.Input value must be given as a string (for example, quoted literals).