If condition that seperates and only shows ID with Null

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

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

[Gysbert_Wassenaar]

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$