Grouping

[#1]

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

[swuehl]

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, ', ')

[#3]

Thank for the quick response, howver if I do 'select excelude' this will still show me all the ID's as they have a List 1 and 3.

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

In this example I would only want to see ID 2 as this is the only ID that does not have a List 2.

Cheers

[swuehl]

For the example given, you want ID = 2 returned, right?

As said, you need to 'select excluded' in the ID list box (not in the List list box).

Or use

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

[#5]

I'm not sure I understand what your saying.

I've attached an example of the data.

All I want to see is the ID's that do not have a List 2 assoicated with it.

Many thanks for your time,

Simon

[swuehl · Accepted solution]

Please check attached.

[#7]

Thank you, that great.

Cheers

Simon