topic Re: 2 field values in single list box in QlikView

2 field values in single list box

Mon, 09 Jun 2014 11:09:32 GMT

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!!!

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:11:28 GMT

Not clear.. Can you post example for same?

Re: 2 field values in single list box

senpradip007 — Mon, 09 Jun 2014 11:12:04 GMT

Try somthing like

=Field1 & '-' & Field2

Re: 2 field values in single list box

ashfaq_haseeb — Mon, 09 Jun 2014 11:12:11 GMT

Hi you can try something like this.

load

F1,

F2,

F1&F2 as F3

from XYZ;

Regards

ASHFAQ

Re: 2 field values in single list box

swuehl — Mon, 09 Jun 2014 11:12:44 GMT

Sorry, I don't fully understand. Could you give some sample data and what you expect?

You can use a field expression (use field drop down on general tab, select <expression> ) to concatenate the two fields:

=A & ' - ' & B

or use A as field and B as expression (on expression tab).

Re: 2 field values in single list box

israrkhan — Mon, 09 Jun 2014 11:14:41 GMT

if i understood your requirement,

Try like

in list box properties, select Expression instead of field.

and write expression like =Year &' '& Month,

in list box i can see Year and month both fields...

Kind Regards

Khan

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:20:04 GMT

Hi All,

Just to make my problem clear.

Usually we use a list box to display single field values by selected that field inside list box.

In my case I'm having 2 fields say A and B I want to display all possible values of A and B in single list box.

I need individual values, not concatenation of the values of 2 fields.

Attached is my sample .qvw files. In this file I'm having 2 list boxes. I want to club values displayed in these 2 list boxes into single list box.

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:22:44 GMT

Hi IsrarKhan ,

Your solution will concatenate values. But I want to display the values as it is without concatenation. Basically I want union of 2 fields into one.

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:23:38 GMT

Hi Pradip ,

I need union of 2 fields not fields not concatenation. Could you please help in this.

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:23:57 GMT

Hi swuehl ,

I need union of 2 fields not fields not concatenation. Could you please help in this.

Re: Re: 2 field values in single list box

ashfaq_haseeb — Mon, 09 Jun 2014 11:24:42 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:26:58 GMT

Hi Ashfaq ,

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

Re: Re: 2 field values in single list box

ashfaq_haseeb — Mon, 09 Jun 2014 11:28:33 GMT

If it is coming from two different table use concatenate.

load * inline

[

];

Concatenate

load * inline

[

];

Regards

ASHFAQ

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:31:01 GMT

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.

Re: Re: 2 field values in single list box

tresB — Mon, 09 Jun 2014 11:32:12 GMT

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

Re: 2 field values in single list box

Mon, 09 Jun 2014 11:41:47 GMT

Try this, will help you

Load * Inline [

a,b

];

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