topic Search with greater than ">" variable in QlikView

Search with greater than ">" variable

Tue, 30 Mar 2010 16:36:06 GMT

Hi,

I wanted to create a button that specifies a search on a field.

The field is "AGE" and the search should be "> vAGE_TRES".

"vAGE_TRES" is a variable and defined as 20.

The problem is that it does not work! When I specifiy "= vAGE_TRES" it accepts the variable and its value, but when I use greater than ">" it does not work.

Any idea?

Search with greater than ">" variable

Tue, 30 Mar 2010 16:48:02 GMT

Your search probably should be

"> $(vAGE_TRES)"

That will change your variable back to a number

= is probably working as a string compare

Search with greater than ">" variable

Tue, 30 Mar 2010 16:54:12 GMT

Also "> $(vAGE_TRES)" does not work.

Search with greater than ">" variable

Tue, 30 Mar 2010 20:42:15 GMT

Hi,

I think you can use a macro to solve the problem something like this in VBS:

sub searching

SET f = ActiveDocument.GetField ("YOURFIELD")

f.Select "YourVariable "

end sub

Maybe it will work

Search with greater than ">" variable

rwunderlich — Wed, 31 Mar 2010 02:13:00 GMT

I'm assuming you are using a V9 action of "Select in Field". Try the following as the Search String in the Action:

='>$(vAGE_TRES)'

-Rob

Search with greater than ">" variable

Wed, 31 Mar 2010 08:50:01 GMT

hi, you an use the following as a macro in your application

sub period

str = ActiveDocument.Variables("vAGE_TRES").GetContent.String

mySelect= ">" & str

ActiveDocument.Fields("Age").Select mySelect

end sub

thanks

Search with greater than ">" variable

Wed, 31 Mar 2010 09:36:22 GMT

Thanks Rob, your solution

='>$(vAGE_TRES)'

worked!

I didn't try the macro yet.

Search with greater than ">" variable

coert — Wed, 21 Apr 2010 14:09:07 GMT

I tried it as well, and it works like a charm......tried for hours and always ended in a dead end street.

Can you maybe explain what the $ does in the equation?

Thanks - Coert

Search with greater than ">" variable

Tue, 04 May 2010 08:25:08 GMT

The $ just evaluates the variable.