topic Re: How to Create Multi Column List Box? in QlikView

How to Create Multi Column List Box?

Sat, 27 Dec 2014 14:12:44 GMT

Hi,

Any one help to create multi column list box.

** Please provide source file ur using fr explaining here. Because i'm using personal edition, Unable to open QVW files.

So, if somebody could help I really appreciate.

Thanks in advance..

Sub2u

Re: How to Create Multi Column List Box?

Gysbert_Wassenaar — Sat, 27 Dec 2014 14:20:55 GMT

Disable the option Single Column for the field(s) in the multibox and enable the Limit Drop-down to option and set it a N lines where N is any number larger than 0 (and smaller than the number of unique values of the field).

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 14:30:48 GMT

Hi,

Is this possible in List Box Object.. i'm trying to display in list box..

Sub2u.

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 14:39:33 GMT

see the steps in following image

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 14:41:57 GMT

Hi,

State	Ufc	Sales
AP	Hyd	10000
AP	KNL	2000
KA	BGLR	24000
KA	MGLR	10300
KA	DVNG	9800
AP	KDP	7200
AP	TPT	5100
MH	MUM	31000
MH	PUN	20400
MH	NGP	26200

This is my Data..I'm trying to display State in List Box..while clicking State ..that respective UFC's will display..

Thanks in advance...

Sub2u

Re: How to Create Multi Column List Box?

SunilChauhan — Sat, 27 Dec 2014 14:42:25 GMT

take a field in list box

and in expression you could write another field of that list box.

Re: How to Create Multi Column List Box?

Gysbert_Wassenaar — Sat, 27 Dec 2014 14:52:21 GMT

Add a list box for Ufc. Select a State in the State list box and in the Ufc list box you will see the respective Ufc values for that the State value you selected..

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 15:54:39 GMT

Enclosed is a file that contains two possible solutions.

1) Is a table box showing just two columns

2) Two Multicolumn list box one for State and the other for UFC , the UFC list box only shows whenever a state has been selected, hope that helps Sub2a

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 15:59:12 GMT

Sorry, I just read that you had PE.

solution 1:

Step 1: Create a list box on State, define it as not single column and arrange at top or wherever you want

Step 2: Create a list box based on Ufc , similiar define it as multi column (unckech single column) and arrange it at one side.

Step 3. Go to Properties on the Ufc list box -> Presentation and Layout -> Condition type GetSelectedCount(State)>0 , this will make the Ufc list box appear just whenever a State has been selected

Solution 2:

Just create a regular Table box with two columns , uncheck Caption and that's it

Re: How to Create Multi Column List Box?

Sat, 27 Dec 2014 16:01:01 GMT

This how the two solutions would look like Sub2a

Re: How to Create Multi Column List Box?

Sun, 28 Dec 2014 03:10:16 GMT

Hi,

Thank you all, I'm trying to display State in one list box and if i selected any state, in that list box only we will display that respective UFC's....

Regards,

Sub2u

Re: How to Create Multi Column List Box?

Sun, 28 Dec 2014 04:20:41 GMT

Very Simple Sub2a.

Go to Document-> Properties and Create a Group. Add State and Ufc name it RegionG for example, check it as a Drill down Group.

Then just create a List Box based on the RegionG group just created and Voila.

Re: How to Create Multi Column List Box?

Sun, 28 Dec 2014 10:29:43 GMT

Hi Mario,

Thanks for your response.

with out group, shall we create with list box..

Regards,

Sub2u.