topic Full select statement not used? in QlikView

Full select statement not used?

Mon, 09 May 2011 16:03:09 GMT

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?

Mon, 09 May 2011 16:31:14 GMT

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?

erichshiino — Mon, 09 May 2011 16:31:58 GMT

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

Full select statement not used?

Mon, 09 May 2011 16:33:43 GMT

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?

Mon, 09 May 2011 16:39:18 GMT

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!