Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If condition that seperates and only shows ID with Null

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

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$


talk is cheap, supply exceeds demand