Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I could use some help here. I have a number of xlsx sheets, looking like the attached that represent the activities in our Operating Rooms (parts are blurred as they are privacy sensitive info). I’ve loaded these xlsx-sheets into one qvd.
From this qvd I want to load only the values that are related to patients and leave the rest of the additional info out. To be able to do this is I need to exclude a number of records, based on the following conditions:
And additionally
My basic load statements from the QVD are:
OK_programma:
LOAD
Datum,
Volgorde,
Kamer_ID,
Patiëntnummer,
Geboortedatum,
"Aangevraagde verrichtingen",
"Aangevraagde verrichtingen (oms.)",
Duur,
"Ingang operatiekamer",
"Uitgang OK",
"Opererende OE"
FROM [lib://Bron_QVD/OK programma.qvd]
(qvd);
I only started the scripting part of Qlik recently and I cannot get my head around this one. I’ve tried several things with If and where statements, but without succes. Help is appreciated!!
What if you put this after the first load:
example:
Load *
Resident OK_Programma
Where Len(Trim(KAMER_(ID))) > 0
OR not match (GEBOORTEDATUM, “1-1-1900”)
What if you put this after the first load:
example:
Load *
Resident OK_Programma
Where Len(Trim(KAMER_(ID))) > 0
OR not match (GEBOORTEDATUM, “1-1-1900”)
Thanks!
This was the solution I've been looking for. It didn't work at first, but that was due to some differences in upper and lower case.