topic Re: Re: Data Model in QlikView

Data Model

Sat, 25 Jan 2014 06:20:23 GMT

Hello All,

I have 2 tables,which are linked by a field say Key

Eg Table 1 has following fields

Key

Statements

Sub Stamenents

Sub statement 1

Sub statement 2

and many other fields

Table 2 has following fields

Key

S_Statement1

S_Sub Statements

S_Sub statement 1

S_Sub statement 2

and many other fields

i want to have field say Statement .When i click on this statement the it should get all the values for Statements and S_Statement1

Similar for all the statements below.

Link table does not work fine,linking between the two tables fail..how can we resolve this problem.

Thanks and Regards,

Priya

Re: Data Model

phaneendra_kunc — Sat, 25 Jan 2014 06:35:01 GMT

"i want to have field say Statement"

This means you will have a third field which is not related/doens't exists in above 2 tables.

What king of data is in your field "Statement"? if it is similar to the data that is available in Statements and S_Statement1?

if so then we can use triggers to achieve that...

so many assumptions... can you through a sample app?

Re: Data Model

Sat, 25 Jan 2014 06:54:51 GMT

Actually the two tables belong to two different database and has only link on basis of key.the statements and S_Statement1 are similar kind of data..

So What i want is all the values in statements and S_Statement1 should be i one field so that on one click i get values from both the database for that particular statement

Re: Data Model

phaneendra_kunc — Sat, 25 Jan 2014 07:15:22 GMT

is there a problem concatenating these 2 tables?

Re: Data Model

Sat, 25 Jan 2014 07:21:06 GMT

Is there any other way

Re: Re: Data Model

phaneendra_kunc — Sat, 25 Jan 2014 07:38:18 GMT

Concatenation is the best way to do it..and it is less confusing.

I tried a different approach with Triggers..see attached..