1 Reply Latest reply: Nov 21, 2009 9:29 PM by Peter Rieper RSS

    join

    bsi

      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 ;

       

        • join
          Peter Rieper

          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