4 Replies Latest reply: May 9, 2011 12:39 PM by Therese Liebermann RSS

    Full select statement not used?

      Hello all...  Please bear with me, I am relatively new to Qlikview.

       

      I have created a button that builds a variable (MyCheck) that is generally something along the lines of:

       

      (>=100<=200) or (>=300<=400) or (>=500<=600)

       

      Then, with a second button, I have it set the selection on a field to match the variable MyCheck.  However, it only selects based on the lower and upper values in the first set of parenthesis, and ignoring the subsequent values.  The full string is shown in the Current Selections box, so it's not that it is only getting part of the variable in the select statement.

       

      The truly confusing part is if I copy the value and manually paste it into the list box search area it properly selects all values.

       

      Anyone have any clue what might be happening?

       

      Thanks,

      Therese

        • Full select statement not used?

          Hello Therese,

          all three expr. work fine (as I expected) in my enviroment. It seems that you have a problem during building the value (searchmask) of your variable MyCheck. Did you watch its value using the (second) button's "caption" with "=MyCheck" in the text-box of the general tab?

          HtH

          Roland

            • Full select statement not used?

              Roland Kunle wrote:

               

              Hello Therese,

              all three expr. work fine (as I expected) in my enviroment. It seems that you have a problem during building the value (searchmask) of your variable MyCheck. Did you watch its value using the (second) button's "caption" with "=MyCheck" in the text-box of the general tab?

              HtH

              Roland


              Yes, I did watch it... both in a text field, and in an input box field.  The statement is built correctly.  In fact, the value I copy and paste is directly out of the input box field. 

               

              Thanks

            • Full select statement not used?
              Erich Shiino

              Hi,

              A syntax like this work for me :

              (>=5<=10|>=12<=15)

               

              I used | instead of the OR

               

              If it doesn't work, please create a small sample application and upload it here

               

              regards,

               

              Erich