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:
The records where the KAMER_(ID) is empty
The records where GEBOORTEDATUM is “1-1-1900” (an alternatieve could be to choose the records where the PATIENTNUMMER is 31779759 or 11780611)
My basic load statements from the QVD are:
"Aangevraagde verrichtingen (oms.)",
FROM [lib://Bron_QVD/OK programma.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!!