topic Re: Select in Field not Working in QlikView

Select in Field not Working

sivarajs — Wed, 21 Jan 2015 13:44:31 GMT

Hi,

My requirement is, when i select a field in list box it should values greater than field1 in field2.

I am using select in field in triggers for a field1.

Data:

Load* inline [

field1

]

Load* inline [

field2

]

When i select 10 in field1 the field2 should select 25,33,45,50.

In triggers i have used field1='=field2>=field1'. This is not working and am using qv11.

Thanks,

Sivaraj

Re: Select in Field not Working

alexandros17 — Wed, 21 Jan 2015 13:52:34 GMT

At the end of Fields list there is an item "Expression", select it and write:

=If(field2>GetFieldSelections(field1), field2, null())

let me know

Re: Select in Field not Working

chrismarlow — Wed, 21 Jan 2015 13:55:12 GMT

Try;

=if(field2>field1,field2,null())

Re: Select in Field not Working

kuba_michalik — Wed, 21 Jan 2015 13:58:29 GMT

Use just:

='=field2>field1'

as the search string (and field2 as field name, of course)

I'm attaching an example.

Re: Select in Field not Working

Clever_Anjos — Wed, 21 Jan 2015 13:59:41 GMT

try

= ">" & only(field1)

Re: Select in Field not Working

sunny_talwar — Wed, 21 Jan 2015 14:00:54 GMT

Try the following Trigger

='>' & Max(field1)

Best,

Re: Select in Field not Working

Anonymous — Wed, 21 Jan 2015 14:02:07 GMT

Hi,

For the list box of 'Field 2', you can use the expression mentioned by Alessandro Saccone.

Then you can check the list box of 'Field 1' as "Always One Selected Value", so that Field2 displays some value always.

Hope this helps!

Re: Select in Field not Working

rwunderlich — Wed, 21 Jan 2015 14:25:59 GMT

For your select in field Search String parameter, use:

='>' & min(field1)

-Rob

http://masterssummit.com

http://robwunderlich.com