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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sami1
Contributor
Contributor

Try to display KPI after scripting Peek function

Hello every one,

I am using Peek function like this:

AR_fournisseurs:
LOAD
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I"
FROM [lib://DataFiles/ARC CDES FOURNISSEURS 2023.xlsx]
(ooxml, embedded labels, table is [Synthèse ARC 2023]);

let Taux_AR_sous_48h = Peek('G',14,'AR_fournisseurs');

I would like to display the value at row 14 from the field "G" in a KPI and I get the following result:

Sami1_0-1699522658059.png

 

Any Idea?

Labels (2)
2 Replies
marcus_sommer

In some way you are not calling the variable-content else displaying the variable-name. What happens if you put a = before the call?

Beside this you are not getting the 14. row else the 15. because the peek-index starts by 0.

I don't know what your data contain and what are the requirements within the views but I think I wouldn't do in this way else adding: rowno() as RowNo to the load and then querying the value per:

only({< RowNo = {14}>} G)

Sami1
Contributor
Contributor
Author

Thanks, I put the wrong row, it works better with row number 13.