Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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!