Seletion using NOT in a complex expression

[#1]

Hey guys,

I am stuck with a pbm here.

I have a table with two fields, let's say F1 and F2

and the data is like:

F1 F2

1 x

1 y

1 z

1 a

2 x

2 y

2 z

2 b

Now, I'll try to explain what I want...

I need the F1 that has no selected value of F2

Examples: If I click and select 'a', it should show only values with F1 = 2 (as for F1=1 there is an 'a' in F2, these should not show up)

If I click and select 'b', it should show only values with F1=1 (as for F1=2 there is a 'b' in F2, these should NOT show up)

If I select 'x', it should show 'no data to display' (as 'x' is in both F1=1 and F1=2)

Please let me know if you have any solution.

Thanks in advance

Srujan

[johnw]

This could probably be solved with an "and mode" list box for F2, and using "forced exclusion" in that list box by clicking and holding until the value turns red. In the attached example of an "and mode" list box, for instance, clear the selections, then click and hold on value "A" until it turns red. Now only ID 3 is displayed because only ID 3 is NOT connected to Type A.

I don't think that would let you force exclusion of X in your example, though. That isn't just no data to display, that's no data selected period, which doesn't seem to be something QlikView is very happy with. I think this is just like regular list boxes, where you can never make a set of selections that results in no data. If your most recent selection would, it may disallow it or clear other selections.

[#3]

Hey John,

Thanks for the reply. Your suggestion might work (excluding the 'no data displayed' scenario). But I am not able to try it on mine because the list box i have doesn't let me select the 'and mode'. It is greyed. Do you know any work around to make it selectable.

thanks again

Srujan

[johnw]

From the help text for "And-Mode in List Boxes":

The AND-mode option is only allowed under very strict conditions, imposed by the theory behind the QlikView logic. In order to be used in AND-mode, the following criteria must be fulfilled:

• the field must only exist in one logical table,

• this table must only contain two fields,

• the field must be the second column,

• the table must not contain any duplicate records, and

• the table must be loaded using Load distinct … (If the table is loaded using a Select distinct … statement, this must be preceded by a Load distinct * ; statement.)

[#5]

Oh wow. That's not easy. So now I'll try to figure out if I could load my data in specified format or not. Anyways, thanks so much. Appreciate your help.