Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I beginning to develop a new dashboard for a workplace accommodation report, I have the following data tables & structure which are all required in the dashboard:
Employees
Buildings
Floors
Rooms
Rooms Transaction (shows employee moves)
Divisions & Departments (organisational structure etc.)
In the dashboard we're looking to show, no of employees, employees with assigned desks & without, no occupied rooms, no of vacant rooms, no of type of rooms (offices, meeting rooms etc.), room capacity, room headcount, rooms with office availability, full rooms, no of moves, no of buildings and so on - so I can't see of way to reduces tables I'm including in the dashboard to make it easier to structure them in a better way.
Many of these tables share same fields (Building Code, Floor Code, Rooms Code etc), its proving a nightmare to set up the best structure in qlikview without creating awful synthetic tables:
Any thoughts anyone can share on best way to set these tables up, to create the best structure?
(shown is the latest attempt)
try to
...
load buildings ....
left join
load rooms ....
left join
load floors...
...
in this way you will have only one synt. key