topic Re: List Box Design in QlikView

List Box Design

Fri, 16 Oct 2015 11:05:27 GMT

Hello Experts,

Since my QlikView dashboard has too many list box I have requirement to redesign the list box in the attached format where it can be minimized maximized based on the requirement.

Can someone please help me on how to achieve this?

Thanks in Advance.

Best Regards,

Bhavesh Jain

Re: List Box Design

jolivares — Fri, 16 Oct 2015 16:25:12 GMT

Take a look if this model accomplish your require...

Re: List Box Design

Fri, 16 Oct 2015 17:27:45 GMT

you can use a combiantion of a multi-box and list boxes to take up less space for your selection criteria

the attached example shows the use of a multii box for filter selections

Re: List Box Design

Anonymous — Fri, 16 Oct 2015 18:07:43 GMT

Bhavesh,

If the dimensions already have groups, as they do in your screenshot, you can write an expression like this within your listbox:

=	AGGR(
		ONLY({1}
			if(len(trim(%DimensionGroup))>1, %DimensionGroup & '\','') & %DimensionLabel
		)
		,%DimensionLabel
	)

Then be sure you have "Show as TreeView" selected in the General tab with Seperator \

Re: List Box Design

Thu, 22 Oct 2015 16:47:16 GMT

Thank you guy's your tricks were awesome but unfortunately did not meet client’s requirement.