Qlikview incorrect relationship..Please help

[#1]

Hello,

I have the attached data model in Qlikview. I am new to Qlikview. Can someone have a look at it and tell me how can i possible remove the wrong relationship.

the internal table viewer shows the below picture

The original relationship is given below

I dont want the link that i have crossed in the red line. I only want the relation that i have marked in red with straight line. The relationship with upper two tables seem okay so i dont want to disturb those. Can someone suggest how can i do this

Thanks in advance

Arif

[#2]

hello

Just rename DBname in v_qv_table_site, s_qv_tgt_tbl_lkp.

[#3]

But that will break the relationship between the upper two tables which are also connected by dbname??

Arif

[#4]

Hi,

QlikView will link fields using their names, so if wou want to change relations you just have to rename or to drop them. In your case you can skip the DBname field from the Database_Size table to avoid the unwanted relation. Another point is that you have relations on two fields, qv will then do a synthetic key, bu you can manage this stuff by yourself by manually creating another table and using something like the autonumber function.

[#5]

Hi,

rename the field name in which table u dnt want the link

[#6]

Hello i think u should try this.

make key field contains all 3 connected fields in database_size, table_size.

then rename dbname in table_size, tgt_tbl_lkp

[#7]

Hii,

Rename the fields in which u need a link and also use the "apply map" function as your one table contain only 2 fields.

[#8]

Hello,

Can you elaborate it a bit more (make key field contains all 3 connected fields in database_size, table_size.). How do we manually change the key fields using script? I am sorry if i sound a bit lame because i am totally new to Qlikview

Arif

Muncho wrote:
Hello i think u should try this.
make key field contains all 3 connected fields in database_size, table_size.
then rename dbname in table_size, tgt_tbl_lkp<div></div>

[#9]

well im also new in qv ^^.
But u can try this.
first u need rename connected fields in table_size this will break connection. then in database_size make key like this:

run_date&dbname&monthname as key

also do this renamed fields in table_size . and it will connect key fields.
then rename dbname in table_size and tgt_btl_lkp.

Just try this maybe it will help you. maybe not [:)