Using multiple data sets simultaneously

[#1]

I'm still getting to grips with Qlikview, but run up against a bit of a brick wall here.

I have two data sets - one tracks all UID logons onto a system, whilst another tracks all the registered UIDs.  What I want to do is to work out the percentage of logons out of the total registrations.  I have loaded both data sets as separate tables in qlikview, and thought I would be able to set it up so that if you selected "Office" as a section in the logon sheet, it would equally select office in the registration sheet.  Then I would see a total from each sheet, and could just divide one by the other to show what percentage of that particular grade/office/department had logged on during the selected time period.

However, all of my searches for linking data across sheets only seems to talk about using a single data set.  Am I going about this the wrong way?

[Clever_Anjos · Accepted solution]

In order to create a link between then, your datasets (tables) should have fields with same name,

Into your example, if you have a field called Office into your UID logons and Office into your registered UID, QlikView kindly will create a key linking your tables

[#3]

Ah, I hadn't realised that - thanks very much!