Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question: What is the selection logic used when selecting excluded values?

Does anyone know the precise logic QlikView uses to amend the selection when an excluded value is selected?

The reference manual says "When an excluded value is clicked, selections in conflict with this value are canceled, and the value clicked becomes selected" but this doesn't explain how it decides *which* selections are in conflict.

e.g. with the following table loaded in QV Desktop V9 SR5:


LOAD * INLINE [
A, B, A+B
1, 1, 2
1, 2, 3
1, 3, 4
2, 1, 3
2, 2, 4
2, 3, 5
3, 1, 4
3, 2, 5
3, 3, 6
];


If I select A = 2, B = 2, and A+B = 4 and then select A = 1 (an excluded value) then there are three things that could logically happen to the other two fields:

  1. Selections in both B and A+B are cleared and a range of possible values corresponding to A = 1 are highlighted in both, or
  2. the selection in B is cleared and will show 3 as a possible value because A+B = 4 is still selected, or
  3. the selection in A+B is cleared and will show 3 as a possible value because B = 2 is still selected

In practice, scenario 2 *always* happens for me when I select an excluded value in A. It doesn't seem to depend on the order in which I make the initial selections. Similarly, selecting an excluded value in B clears A, and selecting one in A+B also clears A.

Does anyone know why/how (in this simple case) QlikView decides to clear the selection in B and not in A+B (or in both)? In general what is the logic used to decide what the new selection will be when an excluded value is selected?

Thanks in advance for any help

Simon

0 Replies