Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please check attached.
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, ', ')
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
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, ', ')
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
Please check attached.
Thank you, that great.
Cheers
Simon