topic Re: Cannot search Negative number. in QlikView

Cannot search Negative number.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

My dashboard has one table which one of the column display % figure. There is one input box to search the % figure from the table. When the user key-in the % figure in the input box, the table should display according to the input % figure.

Just realized that -ve number search does not work. Positive number are working fine though.

How can I do to be able to search -ve number?

Thanks in advance,

Re: Cannot search Negative number.

swuehl — Wed, 15 Jun 2016 10:24:15 GMT

Assuming a value to search like -0.97, try a search string like

*-1.97

(-1.97)

Re: Cannot search Negative number.

Thu, 16 Jun 2016 01:26:33 GMT

Hi Swuehl,

My search value is %. Hence when I key-in (-0.4), it doesn't change to -40% and cannot search. I tried with (-40%),*-40%,*-0.4. Doesn't work.

Any other idea please?

Thank you,

Re: Cannot search Negative number.

swuehl — Thu, 16 Jun 2016 11:45:39 GMT

It does work at my site, so I think I am missing something.

Could you post a small sample QVW containing the field that demonstrates your issue?

Re: Cannot search Negative number.

Fri, 17 Jun 2016 01:48:12 GMT

Hi,

Can please try using input box for search? Currently you are using same object search. Here is the sample.

Thank you,

Re: Cannot search Negative number.

swuehl — Fri, 17 Jun 2016 08:46:03 GMT

Even a selection - select in field action using the input box variable

=vSearch

as search string works fine for me.

When you do a search for -47%, you are searching in a field, I assume field [Short position%], right?

Does this field show this value at all (I can't see -47% in your table)?

Also make sure that you match the format of your field value, i.e. searching in your field [Short position%], you would need to write

(-92.0%)

Re: Cannot search Negative number.

Fri, 17 Jun 2016 08:56:24 GMT

Hi,

My issue has been resolved by removing % formatting from both Input box variable and table column.

In my case I do not need to use * or (). I can just search with -37, -40.

Thanks so much for your reply.

Regards!