Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Niru
Contributor II

List Box

Dear All,

i have a two list boxes

if i select one value in first list box

it could show only based on filters ,its highliting the values it won't filtering

how can i do this is there any expression

i need to show only highlited values

please find the image

Thanks In Avance

Niranjan

Filters.png

11 Replies
nagaiank
Valued Contributor III

Re: List Box

In the Listbox properties, General tab, check 'Hide Excluded'

Niru
Contributor II

Re: List Box

Hi Nagaiank,

Thanks for your valueble reply,

i am getting space in between records how can i remove that space

Best Regards,

Niranjan

jsaradhi
Valued Contributor

Re: List Box

in the Sort tab in properties, select ascending for state. that should help!

nagaiank
Valued Contributor III

Re: List Box

Try to use table box instead of listbox

Niru
Contributor II

Re: List Box

actually im writing some expressiong in listbox


Niru
Contributor II

Re: List Box

Hi jsaradhi,

Thanks for your help full answer

its filtering then how can i remove this space

please find the imageFilters.png

jsaradhi
Valued Contributor

Re: List Box

Yes, unfortunately, the space will always be there if you are using a list box. instead you can use a table chart...so for example your dimension will have the expression you are using for your list box, but in expressions, use =1 and click on the plus sign to the left of the expression and use same color for background color and text color and minimize the size of the column manually or hide the column. this is only one way....there are other ways depending on your data structure and data.

Niru
Contributor II

Re: List Box

Hi Jsaradhi,

I am not getting could you please show me the Process

its helpfull me to modify

Best Regards,

Niranjan

chiru_thota
Valued Contributor

Re: Re: List Box

I have tried to implement by using variables.

List box 1 is CountryCode. you can have a look at attached qvw.

list box.jpg

Community Browser