Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a problem and cant find a solution for it,
The problem Is that I have a person that's got a treatment on a specific date this treatment a unique Treatment_ID. The value is connected to a Folder_ID. I want to separate so that I can se all Folder_ID's that do not contain a DoneDate at al. If a folder contains any DoneDates it should not be shown. Only folders that lack donedates should be shown.
My problem is that some folders contain DoneDate on some rows and missing DoneDate on the row below. I only need the folders that do not have a DoneDate at all.
I have tried a if statement but it shows all the rows that miss DoneDate, and that's not the result I am after. I need all the Folder ID that does not contain any DoneDates at all.
thx
Theo
See attached qvw.
Thanks it helped a lot, I have two questions
count({<COT_ID=E({<DoneDate={'*'}>}COT_ID)>}DISTINCT COT_ID) what does Cot_ID=E achive?
And is it possible to set a similar marker in a load scrtipt?
thx
Theo
1. COT_ID=E({<DoneDate={'*'}>}COT_ID) selects the COT_ID values that do not have any DoneDate.
2. Yes. Maybe by adding this to the script:
Left Join (Blad1$)
LOAD Folder_ID, 1 as Marker WHERE Len(Trim(Temp))=0;
LOAD Folder_ID, max(DoneDate) as Temp
Resident Blad1$