topic Re: Selection based on values entered in Input Box in QlikView

Selection based on values entered in Input Box

Mon, 06 Aug 2012 19:26:13 GMT

Hello All,

I have a requiremnet where i have to search/ filter the values based on data entered in input box. Basically there will be 2 input boxes one with min value and one with max values. Both objects will be based on the same field "Revenue".

can someone help me out ion resolving this issue.

Thanks

Pranav

Re: Selection based on values entered in Input Box

Tue, 07 Aug 2012 08:58:11 GMT

many ways

you need to be more specific (which object, how many expression.... )

check att qvw file

Re: Selection based on values entered in Input Box

a_mullick — Tue, 07 Aug 2012 08:58:36 GMT

Hi,

If you're planning on displayng data where Revenue is between the min and max values, then you should consider using a slider object on the field Revenue. It provides a simpler solution to selecting ranges of data than input boxes.

Hope that helps,

Azam

Re: Selection based on values entered in Input Box

Tue, 07 Aug 2012 11:56:54 GMT

Hello Azan,

i have a slider, but somehow i'm not able to set the min and max values.

Thanks

Pranav

Re: Selection based on values entered in Input Box

Tue, 07 Aug 2012 11:59:48 GMT

Thanks Pari Pari,

I tried your solution based , but whn no min and max values are sellected no data is showing up.

Thanks

Pranav

Re: Selection based on values entered in Input Box

Tue, 07 Aug 2012 12:24:36 GMT

check this

Re: Selection based on values entered in Input Box

a_mullick — Tue, 07 Aug 2012 13:29:20 GMT

Hi Pranav,

I have to admit, I was a bit surprised that this option is not available (you can set min and max with variables, but not with fields)...but QV will automatically determine the min and max values available for your chosen field based on what is in the data, which I think is ok. So if the data ranges from 12000 to 35000, then these will be the min and max values. They will be dynamic too, so if the data changes they will change with it.

BTW you should set Mode to Multi Value to allow the user to select a range.

Regards,

Azam