Problem with Peek

[beck_bakytbek]

Hi Folks,

i got the following situation (see attached file):

i am using the following solution within script area:

temp:
LOAD
Project,
Element,
Invoice,
Data,
Profile
FROM
[Qlik Sense Script 2020\Peek in action.xlsx]
(ooxml, embedded labels, table is Tabelle3);

final:
load *,

if(len(trim(Profile)), Profile,
if(Project = peek(Project) and Element = Peek(Element), Peek(Test1))) as Test1

Resident temp
order by Project, Element, Invoice ;

DROP Table temp;

But if i load the script, i am seeing that the field: Test1 doesn't work. Am i missing something?

Does anybody have any idea?

Thanks a lot for help and feedbacks.

Beck

[rubenmarin]

Hi @beck_bakytbek, there is no file attached, I think you need an 'else' for the 2nd if, so it starts with some value:

if(len(trim(Profile)), Profile,
if(Project = peek(Project) and Element = Peek(Element), Peek(Test1), Test1)) as Test1

[beck_bakytbek]

Hi Rubenmarin,

thanks a lot for your time and feedback, i tried your suggestion, but i didn't achieve the expected result. i try to solve that by another way, when i achieve a solution, i let you know,

Thanks a lot

Beck