2 field values in single list box

[#1]

Hi All,

I want to display 2 fields in single list box by clubbing data in both fields. These 2 fields have some values in common and some are not common so I want to display all the values.

Thanks!!!

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ

[#3]

Hi Ashfaq ,

I want a list box which is having values from 1 till 10 in my case.

[ashfaq_haseeb]

Hi

If it is coming from two different table use concatenate.

load * inline

[

a

1

2

3

4

5

];

Concatenate

load * inline

[

a

6

7

8

9

10

];

Regards

ASHFAQ

[#5]

Hi Ashfaq ,

I dont want to have same column name for both the tables(as shown by you) so qlikview will not do the concatenation/union as my column names are not the same.

Keeping both column names same is giving performance problems because of join which it performs automatically.

[tresesco]

In the front-end you can do it using ValueList(). See attached. But it has limitation. Better to do in the script.

[#7]

Try this, will help you

Load * Inline [

a,b

1,

2,

3,

4,

5

];

Load * Inline [

a,b

6,6

7,7

8,8

9,9

10,10

];

Do not concatenate two tables, instead keep field names same in both tables.

--Lalit