topic Filter fields in script in QlikView

Filter fields in script

CanOls — Sat, 16 Nov 2024 19:02:26 GMT

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.

Any help is appreciated

Casper

Re: Filter fields in script

martinpohl — Wed, 26 Feb 2020 11:54:11 GMT

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