5 Replies Latest reply: Oct 1, 2012 5:28 AM by Adrien Allard RSS

    Advanced aggregation in list boxes

      Hi,

       

      Another exercise for well experienced qlikview users ... I kindly ask your help concerning the issue bellow :

       

      load * inline [

      id, kunnr, parnr, description,

      1, 1, 10, wrong_desc

      2, 1, 20, wrong_desc

      3, 1, 30, wrong_desc

      4, 1, 40, right_desc

      5, 2, 10, wrong_desc

      6, 2, 20, right_desc];

       

      With a one-click in a list box, I would like to select id=4 and 6. It corresponds to cases where, for a given kunnr, parnr is maximal.

       

      If one can redirected me to another related post, I would also greatly appreciate

       

      Thanks a lot !

       

      Adrien