Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we use peek fun in charts?
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.
Unfortunately no, only in script is allowed
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.
bby the way, probably you can achieve the same with FieldValue() and FieldIndex()
best regards
No, but perhaps the functions above, below, before, after, bottom and top can be used instead.
No only in load script like
Eg:-
LET vName = Peek('FieldName', 0, 'TableName');
Eg:-
peek( 'Sales', -2 )
Hope this helps
Thanks & Regards
Hi,
You can't use peek in charts directly. try above() or use variable.
sum( Sales ) / above( sum( Sales ))
above( sum( Sales ), 2 )
above( total sum( Sales ))