Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Champion III
Partner - Champion III

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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