can we use peek fun in charts?

[#1]

can we use peek fun in charts?

[alexandros17]

Unfortunately no, only in script is allowed

[Luis_Cortizo · Accepted solution]

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:

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

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

The result will be this:

Hope it helps.

Best regards.

[Luis_Cortizo]

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

best regards

[Gysbert_Wassenaar]

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

[its_anandrjs]

No only in load script like

Eg:-

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

Eg:-

peek( 'Sales', -2 )

Hope this helps

Thanks & Regards

[#7]

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