Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

join

hi

how can i write this in qlikview?







minp: load

load pr , Eyear from p;

pname ,min(EYear) as MinEYear resident p group by pname;

load if (EYear= MinEYear ,pr) resident p , minp ;

1 Reply
prieper
Honored Contributor II

join

Do not know, whether I understood your question right: You want to load only those values, where EYear is lowest? You may join an indicator for the smallest EYear and the filter for it:

JOIN pname, MIN(EYear) AS EYear, 'min' AS indicator RESIDENT p GROUP BY pname, EYear;
mp: LOAD pname, EYear RESIDENT p WHERE indicator = 'min'; DROP TABLE p;


HTH
Peter

Community Browser