topic Peek Function returning Null in QlikView

Peek Function returning Null

kcvernon — Sat, 16 Nov 2024 00:49:59 GMT

Hello

I am trying to populate a variable using peek function and just keeps returning NULL.

I have tried multiple combinations but still no luck, can anybody see anything that I am missing.. driving me insane.

Many thanks

Fractiles:
Load
Fractile(FIELD1, 0.95) AS FRACTILE95,
Resident Table1;

LET vFRACTILE95 = Peek('FRACTILE95', 0, 'Fractiles');

I have checked the table Fractiles and it is populated with only one row.

Re: Peek Function returning Null

rubenmarin — Thu, 16 Apr 2020 11:15:32 GMT

Hi, which value is stored in FRACTILE95 on Fractiles table? Maybe decimals separator is messing with the value assigned to the variable.

you can try with: Replace(Peek('FRACTILE95', 0, 'Fractiles'), ',', '.')

Re: Peek Function returning Null

Vegar — Thu, 16 Apr 2020 11:22:27 GMT

The expression looks OK to me. How did you check your table? Could it be an empty row at the top?

What if you try to fetch the last row instead. Does that help?

LET vFRACTILE95 = Peek('FRACTILE95', -1, 'Fractiles');

Re: Peek Function returning Null

Brett_Bleess — Thu, 14 May 2020 14:50:20 GMT

If Ruben or Vegar's posts helped, we appreciate it if you return to your thread and use the Accept as Solution button to mark the post(s) that helped you resolve things. If you figured something else out, please consider posting that and then use the button to mark that post as the solution.

Regards,
Brett