topic Re: Range of values. in QlikView

Range of values.

Sun, 26 Apr 2015 18:13:55 GMT

Hi,

I have a dimension Vendor. Users didn't like the function to select more than 1 vendors from listbox. They are looking for a text box where they can enter from and to value to select the list of vendor. Is this possible in qlikview if so how?

Thanks

Re: Range of values.

Anonymous — Sun, 26 Apr 2015 18:19:05 GMT

Use a Slider Object on your Data Field Vendor, setting the mode to Mufti Value.

Re: Range of values.

maxgro — Sun, 26 Apr 2015 18:30:54 GMT

an input box with 2 variables vStartVendor, vEndVendor

and set analysis

Sum({< Vendor= {">=$(vStartVendor)<=$(vEndVendor)"} >} SalesAmount)

Re: Range of values.

Sun, 26 Apr 2015 18:39:52 GMT

I used the input box but user didn't like how they look the variable name with = symbol there is there anyway to get rid of that = symbol or have a text box as input box?

Re: Range of values.

sunny_talwar — Sun, 26 Apr 2015 18:46:27 GMT

You can get rid of the equal sign within the presentation tab of the input box properties (take a look at the image below)

and you can change the display name of the variable also:

I hope this helps.

Best,

Sunny

Re: Range of values.

MarcoWedel — Sun, 26 Apr 2015 22:39:40 GMT

Hi,

another possibility could be to use triggers with selection actions to select the Vendor field by filling two input boxes:

hope this helps

regards

Marco