Problems with relationships

[#1]

Hello,

Attached is a demo of my problem.

They need to select the filter values ??to be returned NomeRegiao ValorVend and ValorMeta.

Thank you.

[#2]

Help!!

[Miguel_Angel_Baeyens]

Hi Robertta,

Your document has a synthetic key, but it's working fine as far as I can see: if I select Segemento: CIM the chart only shows that line. Can you elaborate on what do you expect?

Regards,

Miguel

[#4]

Hi Michael,

What I hope to select Segment: CIM filter NomeRegião give me the ability to select and CO SOUTH.

You idea how I can do this?

[Miguel_Angel_Baeyens]

Hi Robertta,

All tables are linked, and according to your script, that is not possible since CIM is linked to NomeRegiao SUL, but not CO, that will only be available if you select Segment EMP. QlikView links tables when at least one field shares the name with another table. In your case, (you can easily see that using the table viewer or Ctrl + T) you have your Itens and NF_Saida linked by three fields: Nota, Vendedor and NomeRegiao.

If that linkage does not respond to your idea of the data model, you may need to JOIN instead of CONCATENATE, or rename fields so only one makes the link.

Hope that makes sense.

Miguel