topic Set a field to be less than a value on a button click in QlikView

Set a field to be less than a value on a button click

Fri, 14 Jan 2011 18:53:24 GMT

I'm having trouble figuring out how to make a field less than an entered textbox value on a button press.

I have a field called Sales and a textbox where the user can enter a number. What i'm trying to do is after the user enters a number and presses the button, the page will only show sales less than that number.

So in the action dialog under "Select in Field" and i the "Search String" box i've been trying to set a field Sales to <MAX(EnteredNumber).

This isn't working though. Any ideas? Thanks!

Set a field to be less than a value on a button click

hector — Fri, 14 Jan 2011 19:00:56 GMT

Hi, with this sintax in the search string worked for me


= '< $(=InputValue)'

Set a field to be less than a value on a button click

Fri, 14 Jan 2011 20:04:21 GMT

Thanks Hector works Great. I wasn't really sure what was acceptable in "search string". Seems like a funny name for that field but oh well, it works!

Set a field to be less than a value on a button click

Fri, 14 Jan 2011 20:25:15 GMT

Hetor, if you dont mind i would also be interested in knowing how to do this for 2 values. So that sales is between two entered fields.

= '< $(=InputValue1) AND > $(=InputValue2) doesn't work

Thanks.
'

Set a field to be less than a value on a button click

hector — Fri, 14 Jan 2011 20:37:00 GMT

the problem is the "AND" word, try with


= '> $(=InputValue1) < $(=InputValue2)'

Remember when you are filtering in the field, you don't use the "AND" word, you just use >5<=10

Rgds