Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
NavinReddy
Contributor II

listbox

Dear All,

i have filtered some values in listbox,

after filtering i got white color space how can i remove space

its filtering then how can i remove this space

please find the image

Thanks In Advance

NiranjanFilters.png.bmp

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: listbox

Hi, Try using the the Only function. I have demonstrated it in my application which is attached below. I have used it in the Sale field of my qvw. Hope it helps.

Set the size of listbox to fixed so it will not create layout problems by unchecking the size to data from layout tab.

View solution in original post

14 Replies
Highlighted

Re: listbox

probably you have checked "Hide excluded" in this way excluded values shows with another color and it is not possible to avoid this behaviour

Highlighted
Not applicable

Re: listbox

Hi, Try using the the Only function. I have demonstrated it in my application which is attached below. I have used it in the Sale field of my qvw. Hope it helps.

Set the size of listbox to fixed so it will not create layout problems by unchecking the size to data from layout tab.

View solution in original post

Highlighted
Not applicable

Re: listbox

SIZE2Data.JPG.jpgOn the layout tab, make sure "Size to Data" is checked.

Highlighted
NavinReddy
Contributor II

Re: listbox

Hi Deepak,

I am using personal edition
could you please share ur expression

Best Regards,
Niranjan

Highlighted
NavinReddy
Contributor II

Re: listbox

Hi Chirstian,

I tried but its not working for me

Regards,

Niranjan

Highlighted
SunilChauhan
Esteemed Contributor

Re: listbox

Hi Niru,

I believe its by default from qlikview.

we can not amend that.because if you remove filetr

white space will  be no more.

or you can reduce the height of Listbox

Thanks

Sunil

Highlighted
srchilukoori
Valued Contributor

Re: Re: listbox

Size to data works.

Highlighted
NavinReddy
Contributor II

Re: listbox

Hi srchilukoori,

sorry i tried but its not working for me

size to data

Thanks,

Niranjan

Highlighted
SunilChauhan
Esteemed Contributor

Re: listbox

I thing its not possible. but lets i was also trying for the same but cant find solution.

i will appreciate if somebody can reply on this.

But dont thing its possible.