topic Select in field: select numerical range (Greater than x but smaller than x) in QlikView

Select in field: select numerical range (Greater than x but smaller than x)

isciberras — Sat, 16 Nov 2024 03:01:50 GMT

Hi,

I would like to use "select in field" to create a button which filters a column for a specific range of financial data.

For example filtering on a column (financial data) greater than 300 but smaller than 10000

Is it possible to do this with Select in field?

I tried the above but it didn't work

Thanks

Re: Select in field: select numerical range (Greater than x but smaller than x)

sergio0592 — Thu, 11 Jul 2019 14:05:01 GMT

Hi,

You should use Slider for this--->New sheet object--->Slider/calendar object

Re: Select in field: select numerical range (Greater than x but smaller than x)

Brett_Bleess — Tue, 06 Aug 2019 15:41:06 GMT

You are on the right track, I think it is most likely a syntax thing in this case, but I stink at these things, so I am not sure what you are missing here. You could try single or double quotes around things or maybe an = in the front of things, sorry I am not sure about this, but you can give these a try to see if it changes anything. Someone else may see things as well and know and leave you another message too.

Regards,
Brett

Re: Select in field: select numerical range (Greater than x but smaller than x)

lockematthewp — Tue, 06 Aug 2019 18:59:35 GMT

You almost had it.

='>300<10000'