Please see the attached Qlikview. I have changed fields to reduce the problem to few tables and generic names.
Click the button (note its Actions will affect a selection).
Once the selection happens, you can't change from 2012-12-31 to 2013-12-31.
I explained it further in the Qlikview, but you can also see details below:
Thoughts?
DetailData:
LOAD * INLINE [
DetailDescription, DetailId, Joiner
not this thing, 1, 21000-12/31/2014
not this thing, 2, 0-12/31/2014
not this thing, 3, 16951-12/31/2013
why is this screwed, 4, 0-12/31/2013
want this thing, 5, 15209-12/31/2012
want this thing, 6-ignore, 0-12/31/2012
want this thing, 7, 16951-12/31/2013
want this thing, 8-ignore, 0-12/31/2013
];
TopLevelData:
LOAD * INLINE [
Year, Joiner
2012-12-31, 15209-12/31/2012
2012-12-31, 0-12/31/2012
2013-12-31, 16951-12/31/2013
2013-12-31, 16157-12/31/2013
2013-12-31, 0-12/31/2013
2014-12-31, 21000-12/31/2014
2014-12-31, 0-12/31/2014
];
CouldDropThisTableThatWouldFix:
LOAD * INLINE [
SourceFile, Year
a, 2012-12-31
b, 2013-12-31
c, 2014-12-31
];
While the button unlocks, clears all, and enacts this selection as my starting point:
- Select in Field; DetailId = (5)
- Select in Field; Year = 2012-12-31
- Select in Field; DetailDescription = *want*
- Lock Field; DetailDescription
And from that point, Qlikview won't allow me to change my expression to 2013-12-31...
It does allow your selection to change if any of these conditions were met:
- DetailDescription search string was '*thing*' instead of '*want*'
- I guess because it stretches DetailDescription to something else which exists in 2013-12-31
- DetailId search string was '(5|7)' instead of '(5)'
- I guess because 7 exists in the 2013-12-31, the new selection would not be mutually exclusive
- Dropped the third table CouldDropThisTableThatWouldFix; see load script
- I have no idea why this helps
