topic Link ??? in QlikView

Link ???

Wed, 09 Feb 2011 15:01:44 GMT

Sorry to ask you basic question.

I have 2 fields from 2 tables (MySQL database).

Table Field Field Value

A Office 1,2,3 etc

B Sales 1500,2500,3000 etc

If I want to see Sales per each office ??..How can I achieve this ?...Do I need to link them ??

Many thanks

Link ???

Wed, 09 Feb 2011 15:37:08 GMT

After you've loaded your tables go to the create chart menu and create a straight table.

On the dimensions tab add Office and on the Expresions tab you can use something like sum(Sales) and then click Finish.

Your table should now show something like

Link ???

Wed, 09 Feb 2011 16:25:09 GMT

Marta

I tried your solution but not working. May be you thought both fields are from same table but they are not. Both fields are from different tables as i mentioned above.

Can i have any other solution ?

Many thanks

Link ???

Wed, 09 Feb 2011 16:38:54 GMT

Sorry I totally misunderstood the question,

You do have to link them through some field, for example if table B has an OfficeID or an EmployeeID that is linked to an Employee table where you can find her OfficeID. Both fields need to have the same name so Qlikview can link them. Let me show you a diagram so you can see what i mean.

This way you can link the EmployeeID to the TableB where the Sales is or something like that.

Hope you understand and this is what you're looking for.

Regards.