Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Range of values.

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

5 Replies
Anonymous
Not applicable
Author

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

maxgro
MVP
MVP

an input box with 2 variables vStartVendor, vEndVendor

and set analysis

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

Not applicable
Author

Hi

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?

sunny_talwar

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

Equal Sign.PNG

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

Label.PNG

I hope this helps.

Best,

Sunny

MarcoWedel

Hi,

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

QlikCommunity_Thread_161741_Pic1.JPG

QlikCommunity_Thread_161741_Pic2.JPG

QlikCommunity_Thread_161741_Pic3.JPG

hope this helps

regards

Marco