topic Problems with relationships in QlikView

Problems with relationships

Thu, 22 Dec 2011 19:15:25 GMT

Hello,

Attached is a demo of my problem.

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

Thank you.

Problems with relationships

Thu, 22 Dec 2011 19:47:01 GMT

Help!!

Problems with relationships

Miguel_Angel_Baeyens — Thu, 22 Dec 2011 19:53:06 GMT

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

Problems with relationships

Thu, 22 Dec 2011 20:46:55 GMT

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?

Problems with relationships

Miguel_Angel_Baeyens — Thu, 22 Dec 2011 21:03:34 GMT

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