Full select statement not used?

[#1]

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

[#2]

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

[erichshiino · Accepted solution]

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

[#4]

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

[#5]

Erich Shiino wrote:

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

Perfect!  That seems to have solved it.

Thanks so much!