topic Re: Using multiple data sets simultaneously in QlikView

Using multiple data sets simultaneously

Tue, 03 Dec 2013 11:44:18 GMT

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?

Re: Using multiple data sets simultaneously

Clever_Anjos — Tue, 03 Dec 2013 11:47:20 GMT

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

Re: Using multiple data sets simultaneously

Tue, 03 Dec 2013 14:06:38 GMT

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