topic Re: Multi Box Filters sorting and shrinking in QlikView

Multi Box Filters sorting and shrinking

Mon, 24 Sep 2012 12:41:42 GMT

Hi,

I have enabled the sorting option of 'Sort by State - Ascending' and also i have checked 'Hide Excluded' option. So i m getting only the possible values in the filter in ascending order. But i am also getting empty rows after the possible values in the list.

Is it possible to truncate or shrink those empty rows. Pls help me.

Malathi

Re: Multi Box Filters sorting and shrinking

m_woolf — Mon, 24 Sep 2012 13:23:09 GMT

Try:

aggr(Fieldname,Fieldname) as the expression

Re: Multi Box Filters sorting and shrinking

Wed, 26 Sep 2012 14:15:56 GMT

Hi,

Thanks for your inputs. Unfortunately it is not working.

Could you help me with any other solution?

Regards,

Malathi

Re: Multi Box Filters sorting and shrinking

m_woolf — Wed, 26 Sep 2012 14:41:03 GMT

When I use the expression: =aggr(Fieldname,Fieldname) instead of the Fieldname, the Multibox does not show items that are excluded. It shows only the possible items.

Can you attach a screen shot of your expression and what the multibox looks like when pulled down?

Re: Multi Box Filters sorting and shrinking

Thu, 27 Sep 2012 06:32:23 GMT

When i tried the options given by you, i m getting the drop down values as above,

Also i have disabled the 'Hide Excluded' option in the presentation.

I want only the possible values in the filter and the drop down length should shrink to possible values.

Re: Multi Box Filters sorting and shrinking

m_woolf — Thu, 27 Sep 2012 10:04:04 GMT

I am not talking about putting the expression in the sort tab.

In the General tab, use the expression instead of displaying a field.

In place of the Area field use: aggr(Area,Area)

Re: Multi Box Filters sorting and shrinking

Mon, 08 Oct 2012 05:05:31 GMT

Thanks a lot. It really worked well. But i could not understand the logic behind it. Could you please explain me.