Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator 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
Not applicable

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
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable

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.

Not applicable

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

NavinReddy
Creator II
Creator II
Author

Hi Deepak,

I am using personal edition
could you please share ur expression

Best Regards,
Niranjan

NavinReddy
Creator II
Creator II
Author

Hi Chirstian,

I tried but its not working for me

Regards,

Niranjan

SunilChauhan
Champion
Champion

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

Sunil Chauhan
srchilukoori
Specialist
Specialist

Size to data works.

NavinReddy
Creator II
Creator II
Author

Hi srchilukoori,

sorry i tried but its not working for me

size to data

Thanks,

Niranjan

SunilChauhan
Champion
Champion

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.

Sunil Chauhan