Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can we use peek fun in charts?

can we use peek fun in charts?

1 Solution

Accepted Solutions
Luis_Cortizo
Employee
Employee

No, it's a script function.

If I reload my script and write:

LET vTest = peek('Field', 0, 'TestTable');

And then on the layout level I create a text object with =vTest this is what I get:

TestPeek.PNG.png

However, if I create a text object with this statement:

=peek('Field', 0, 'TestTable')

The result will be this:

TestPeek.PNG.png

Hope it helps.

Best regards.

View solution in original post

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately no, only in script is allowed

Luis_Cortizo
Employee
Employee

No, it's a script function.

If I reload my script and write:

LET vTest = peek('Field', 0, 'TestTable');

And then on the layout level I create a text object with =vTest this is what I get:

TestPeek.PNG.png

However, if I create a text object with this statement:

=peek('Field', 0, 'TestTable')

The result will be this:

TestPeek.PNG.png

Hope it helps.

Best regards.

Luis_Cortizo
Employee
Employee

bby the way, probably you can achieve the same with FieldValue() and FieldIndex()

best regards

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, but perhaps the functions above, below, before, after, bottom and top can be used instead.


talk is cheap, supply exceeds demand
its_anandrjs
Champion III
Champion III

No only in load script like

Eg:-

LET vName = Peek('FieldName', 0, 'TableName');


Eg:-

peek( 'Sales', -2 )


Hope this helps

Thanks & Regards





Not applicable
Author

Hi,

You can't use peek in charts directly. try above() or use variable.

Examples:

sum( Sales ) / above( sum( Sales ))

above( sum( Sales ), 2 )

above( total sum( Sales ))