Select in value issue

[kulasekhar]

Hi Guys,

I have one requirement, I have one field Month which contains negative and positive values like -19,-15,-6,-3,4,5...

I have one text box If i click text box then it should select the values from -15 to -3 in 'Month' field.

I have tried many ways if it is a positive value it's working fine but here i need to select negative value that's why i'm unable to select those values  -15,-14,-13,-12,-11,-10,-9,-8,-7,-6,-5,-4,-3.

Could you please anybody have a look into this?

i'm attaching sample QVW also.

Thanks,

Sekhar

[Anonymous]

Try using this for your search string in your Text Box action

     <=-3>=-15

[sunny_talwar]

I think you don't need fabs here and also made other minor changes to your select in field expression:

='('& Concat(Distinct If(Month<=-3 and Month >=-15,Month), '|') & ')'

[sunny_talwar · Accepted solution]

Also attaching your application for reference. (PFA)

Best,

Sunny

[sunilkumarqv]

In

select in Field

Field as Month

Search string <0

then if you select then it shows only negative values .

see attached

[kulasekhar]

Hi Sunindia,

Thanks for reply. It's working for me.

I have used ='('& Concat(Distinct iF(Month<=-3 and Month >=-15,Month&'|'))&')' that'swhy i'm getting error.

Thanks,

Sekhar