Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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