topic Re: Grouping in QlikView

Grouping

Wed, 11 Jul 2012 10:19:34 GMT

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

swuehl — Wed, 11 Jul 2012 10:25:45 GMT

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

Re: Grouping

Wed, 11 Jul 2012 10:38:53 GMT

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

Re: Grouping

swuehl — Wed, 11 Jul 2012 10:43:42 GMT

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

Re: Grouping

Wed, 11 Jul 2012 11:47:22 GMT

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

Re: Grouping

swuehl — Wed, 11 Jul 2012 13:31:29 GMT

Please check attached.

Re: Grouping

Wed, 11 Jul 2012 14:58:41 GMT

Thank you, that great.

Cheers

Simon