6 Replies Latest reply: Jul 11, 2012 10:58 AM by Simon Lee RSS

    Grouping

      Hi,

       

      In my head this seems like a simple problem, which I should be able to solve. Now I think I can do it in Loading, but was wondering if it would be better yto do it actually in QlikView.

       

       

      I have a table which contacts and ID and a List.

       

      What I need to know is which ID dont have a specific List:

       

       

      ID               List

      1               List 1

      2               List 1

      3               List 1

      1               List 2

      3               List 2

      1               List 3

      2               List 3

      3               List 3

       

       

      So basicaly I want to know which ID's dont have List 2 for eaxample (which would be ID 2 in the above example.

       

      I know I should be able to do a Group By in Loading to work it out, is that the best way or can it be done in QlikView?

       

      Cheers

       

      Simon

        • Re: Grouping
          Stefan Wühl

          I think you can do this easily in the frontend, using the associative logic:

           

          You can select 'List 2' in a field 'List' list box and then use 'select excluded from the context menu in the field list box for field ID.

           

          Or use a textbox with a set expression:

           

          =concat ({<ID = e({<List = {'List 2'}>})>} distinct ID, ', ')