listbox connections and alternate states

[Anonymous]

hi,

my problem is:

table a >> listbox a

table b >> listbox b

listbox c >> both table a and table b

how can I connect them like that?

it seems impossible because you can choose only one alternate state for one table.

PLEASE HELP.

thanks.

[Gysbert_Wassenaar]

You can't put two fields into one listbox. So what you want is not possible unless you first create a field in the load script with the values from both tables with something like this:

LinkTable:

LOAD distinct FieldA, FieldA as ListboxField FROM TableA;

LOAD distinct FieldB, FieldB as ListboxField FROM TableB;

[Anonymous]

it is not about listbox fields.

table 1

name     day               value

a          20150501          10

b          20150502          20

a          20150502          15

c          20150503          25

listbox1 (connected to table1)

a

b

c

________________________________________________

table 2

name     day               value

d          20150501          10

e         20150502          15

e         20150502          25

d         20150503          35

listbox2 (connected to table2)

d

e

__________________________________________________

and I want ı third list box

listbox3

day

20150501

20150502

20150503

ı want to connect this listbox to both table1 and table2

thanks.

[Gysbert_Wassenaar]

Same difference:

LinkTable:

Load distinct DayA, date(date#(DayA,'YYYYMMDD'),'YYYYMM') as ListBox3 From TableA;

Load distinct DayB, date(date#(DayB,'YYYYMMDD'),'YYYYMM') as ListBox3 From TableB;

[Anonymous]

ok but how will we manage the ALTERNATE STATES??

there are not connected unless you choose same ALTERNATE STATE

[Gysbert_Wassenaar]

I'm beginning to think we're talking about different things. Please post a qlikview document with data and an explanation of what you're trying to do.

[Anonymous]

ı am talking about very very simple thing.

Can you explain me, how do we connect a listbox to a certain table?

how do we tie it? when we click a listbox to effect a table

than ı will ask my question.

thanks.

[awhitfield]

Methinks

List A and Table A = alt state 1

List B and Table B = alt state 2

List C should affect both Table A and B

Andy

[Gysbert_Wassenaar]

What do you mean by 'table'? A table box object or a table in the data model?

[jonathandienst]

List boxes do not connect to tables, they connect to fields, irrespective of the tables. If the field is a key field (common to more than one table), then all the values from all tables will be reflected in the list box.

It is possible to write an expression in the list box that is filtered to one table, provided there us a field in that table that is never null. Something like

     Aggr(Only({<RowID={*}>} Field)

(where RowID exists only in TableA and is never null, and Field is what you want in the list box)