topic Re: listbox in QlikView

listbox

NavinReddy — Fri, 21 Mar 2014 14:17:06 GMT

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

Niranjan

Re: listbox

alexandros17 — Fri, 21 Mar 2014 14:22:48 GMT

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

Re: listbox

Fri, 21 Mar 2014 14:28:27 GMT

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.

Re: listbox

Fri, 21 Mar 2014 14:30:25 GMT

On the layout tab, make sure "Size to Data" is checked.

Re: listbox

NavinReddy — Fri, 21 Mar 2014 14:53:23 GMT

Hi Deepak,

I am using personal edition
could you please share ur expression

Best Regards,
Niranjan

Re: listbox

NavinReddy — Fri, 21 Mar 2014 15:16:03 GMT

Hi Chirstian,

I tried but its not working for me

Regards,

Niranjan

Re: listbox

SunilChauhan — Fri, 21 Mar 2014 15:21:26 GMT

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

Re: Re: listbox

srchilukoori — Fri, 21 Mar 2014 15:32:09 GMT

Size to data works.

Re: listbox

NavinReddy — Fri, 21 Mar 2014 15:53:10 GMT

Hi srchilukoori,

sorry i tried but its not working for me

size to data

Thanks,

Niranjan

Re: listbox

SunilChauhan — Fri, 21 Mar 2014 15:57:43 GMT

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.

Re: listbox

Anonymous — Fri, 21 Mar 2014 16:02:18 GMT

a combination of two solutions provided here will achieve the OP's requirement.

1. use the following expression for list box...this is from Deepak's solution file.

Aggr(Only(Sale),Sale)

2. check size to data in layout tab for the new listbox. that should help!

Re: listbox

SunilChauhan — Fri, 21 Mar 2014 16:05:15 GMT

i suggest if you have qliktech support email then you can ask them.

they will help you

Re: listbox

NavinReddy — Fri, 21 Mar 2014 16:11:53 GMT

Hi jsaradhi,

Thanks for your reply listbox one field its working

but i need to show Empname,Pay _amount in one list box

please help me how can i do this

Regards,

Niranjan

Re: listbox

Anonymous — Fri, 21 Mar 2014 16:17:56 GMT

good...please mark all the answers that helped you above as helpful!

if you need to show Empname and Pay_amount in one list box....create a list box with Empname as the field. in expressions tab use a simple expression like:

sum(Pay_amount)

that should show both fields in the same list box.

Re: listbox

Mon, 24 Mar 2014 07:42:18 GMT

I attached the application right... Please check that...