0 Replies Latest reply: Oct 23, 2016 12:59 PM by Nathaniel Anderson RSS

    Why wont Qlikview allow my selection to change

    Nathaniel Anderson

      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