topic Show 2 Fields in 1 List Box in QlikView

Show 2 Fields in 1 List Box

Wed, 02 Jun 2010 09:23:12 GMT

I have 2 fields which are both lists of countries. I want to show both the lists in 1 list box. There is overlap between the 2 lists so that I will not want duplicates to be shown.

Is it possible to show 2 lists in 1 list box?

Thanks for your help.

Andy

Show 2 Fields in 1 List Box

Anonymous — Wed, 02 Jun 2010 09:26:53 GMT

You mean you want 2 lists to be one list??

In the load you should already combine these two ...

Show 2 Fields in 1 List Box

Wed, 02 Jun 2010 10:38:01 GMT

Hi AndyMercer,

While loading load one field in first time, then second field in again.

let country1 and country2 are the two fields ina same table....

LOAD

country1 as

con

FROM

(

biff, embedded labels, table is Sheet1$)

;

LOAD

country2

con

FROM

(

biff, embedded labels, table is Sheet1$)

;

hope this will help you..

regards

bharathe

Show 2 Fields in 1 List Box

Wed, 02 Jun 2010 11:16:07 GMT

Hi Bharathe,

I dnt get you on the above answer, cos i was also think for a same question ..........plzz if can u explain briefly

because i think , i have to combine two fileds and alias it. thn show it in list box.

Show 2 Fields in 1 List Box

Wed, 02 Jun 2010 12:14:46 GMT

Ashwin,

if you are having 2 fields say(country1 and country 2) in a same table, then load one field (i.e country) alone in first with alias name con.

this can be done by

LOAD country1 as con

FROM

(biff, embedded labels, table is Sheet1$);

then load the table again only with second field (i.e country2) in the edit script with alias name con

this can be done by

LOAD country2 as con

FROM

(biff, embedded labels, table is Sheet1$);

then go to sheet objects... list box.. field(con)...

u can get data of country1 and country2 in the same field con.

Show 2 Fields in 1 List Box

Wed, 02 Jun 2010 12:21:35 GMT

This is my source file ...

country1 country2

ind china

aus US

eng jap

Having country1 and country2 as fields....

Type the following code in edit script

LOAD country1 as con

FROM

(biff, embedded labels, table is Sheet1$);

LOAD

country2 as con

FROM

(biff, embedded labels, table is Sheet1$);

Here we are loading each field with alias name....

After reloading the script.... Go to sheet objects... listbox... then in fields -con.

You will get the following list box

con

--------

ind

aus

eng

china

jap

I hope you ll understand now... reply if this works....

regards

bharathe