topic Select in value issue in QlikView

Select in value issue

kulasekhar — Mon, 11 May 2015 13:38:41 GMT

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

Re: Select in value issue

Anonymous — Mon, 11 May 2015 13:47:08 GMT

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

<=-3>=-15

Re: Select in value issue

sunny_talwar — Mon, 11 May 2015 13:49:25 GMT

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), '|') & ')'

Re: Select in value issue

sunny_talwar — Mon, 11 May 2015 13:50:08 GMT

Also attaching your application for reference. (PFA)

Best,

Sunny

Re: Select in value issue

sunilkumarqv — Mon, 11 May 2015 13:52:51 GMT

select in Field

Field as Month

Search string <0

then if you select then it shows only negative values .

see attached

Re: Select in value issue

kulasekhar — Mon, 11 May 2015 15:33:26 GMT

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