previous value in tooltip

[saharadi]

Hello, 

i want to create a KPI that show "CurrentClient" (no problem) and in the tooltip it show the one before the last on of "ClientHistory" (here i need help)

for exampe in the table below: 
in tooltip of KPI it need to show Google
can it be possoble? 

[MatheusC]

Hi, @saharadi 

Try the Peek() function in your script, for example:

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

************************************************************************************************************************
TablePeek:
Load
ClientHistory,
Peek(‘ClientHistory’,-1) as ClientHistoryPeek
Resident YourTable Order by ClientHistory desc;



- Regards, Matheus

[Chanty4u]

Try this 

Above(Only({<ClientHistory>} ClientHistory), 1)