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: 
CanOls
Contributor III
Contributor III

Filter fields in script

Hi QlikCommunity

I have a dataset with project names and deadline dates. Some projects have multiple deadline dates. I am only interested in the oldest date. My question is, how do I filter out the remaining dates in the script so I only load one deadline date pr. project?

This is how it could look. I have highlighted the dates that needs to be loaded in if a project has multiple values.

temp_QV.png

 

Any help is appreciated 

Casper

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

Data_temp:

load

Project_name,

"Deadline Date"

from Yoursource;

left join load

Project_name,

min("Deadline Date") as MinDate

resident Data_temp

group by Project_name:

Data:

load

Project_name,

"Deadline Date"

resident Data_temp

where "Deadline Date" = MinDate;

drop table Data_temp;

regards

View solution in original post

1 Reply
martinpohl
Partner - Master
Partner - Master

Data_temp:

load

Project_name,

"Deadline Date"

from Yoursource;

left join load

Project_name,

min("Deadline Date") as MinDate

resident Data_temp

group by Project_name:

Data:

load

Project_name,

"Deadline Date"

resident Data_temp

where "Deadline Date" = MinDate;

drop table Data_temp;

regards