topic Re: model? in QlikView

model?

Anonymous — Tue, 10 Feb 2015 12:07:29 GMT

i have 3 tables

i want develop data model here

as per my req is i want concatenate all tables but it is not showing relation ship between the fields ?

is there any way to do this ?

when i put listbox for each field data is there

when i go for table box with multiple fields or checking datamodel using preview it is showing like '-' this symbol(null)

but when i go with listbox it is showing complete data

what is problem here

why concatenate is not working ?

Re: model?

robert_mika — Tue, 10 Feb 2015 12:21:49 GMT

Do you have any common column name within your tables?

Let say this will concatenate:

t1:

load * Inline

[

5];

t2:

Load * Inline

[no

but this not

t1:

load * Inline

[

5];

t2:

Load * Inline

[number

Re: model?

Anonymous — Tue, 10 Feb 2015 15:00:11 GMT

but here i have only one common field

between table1 and table2

other than that i dont have any common key

Re: model?

robert_mika — Tue, 10 Feb 2015 17:32:20 GMT

Is possible to create synthetic key ,could you post your data?

Re: model?

NickHoff — Tue, 10 Feb 2015 21:09:33 GMT

Concatenate won't work unless you have the same table structure in each table. You'd be better off joining the tables into one based on your key fields.