topic Dreadful data structure - ideas sought to improve !!! in QlikView https://community.qlik.com/t5/QlikView/Dreadful-data-structure-ideas-sought-to-improve/m-p/972471#M980461 <HTML><HEAD></HEAD><BODY><P>I beginning to develop a new dashboard for a workplace accommodation report, I have the following data tables &amp; structure which are all required in the dashboard:</P><P>Employees</P><P>Buildings</P><P>Floors</P><P>Rooms</P><P>Rooms Transaction (shows employee moves)</P><P>Divisions &amp; Departments (organisational structure etc.)</P><P></P><P>In the dashboard we're looking to show, no of employees, employees with assigned desks &amp; 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.</P><P></P><P>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:</P><P></P><P>Any thoughts anyone can share on best way to set these tables up, to create the best structure?</P><P>(shown is the latest attempt)</P><P><IMG alt="accom qlik map.png" class="jive-image image-1" src="/legacyfs/online/96679_accom qlik map.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Fri, 21 Aug 2015 13:45:36 GMT 2015-08-21T13:45:36Z Dreadful data structure - ideas sought to improve !!! https://community.qlik.com/t5/QlikView/Dreadful-data-structure-ideas-sought-to-improve/m-p/972471#M980461 <HTML><HEAD></HEAD><BODY><P>I beginning to develop a new dashboard for a workplace accommodation report, I have the following data tables &amp; structure which are all required in the dashboard:</P><P>Employees</P><P>Buildings</P><P>Floors</P><P>Rooms</P><P>Rooms Transaction (shows employee moves)</P><P>Divisions &amp; Departments (organisational structure etc.)</P><P></P><P>In the dashboard we're looking to show, no of employees, employees with assigned desks &amp; 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.</P><P></P><P>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:</P><P></P><P>Any thoughts anyone can share on best way to set these tables up, to create the best structure?</P><P>(shown is the latest attempt)</P><P><IMG alt="accom qlik map.png" class="jive-image image-1" src="/legacyfs/online/96679_accom qlik map.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Fri, 21 Aug 2015 13:45:36 GMT https://community.qlik.com/t5/QlikView/Dreadful-data-structure-ideas-sought-to-improve/m-p/972471#M980461 2015-08-21T13:45:36Z Re: Dreadful data structure - ideas sought to improve !!! https://community.qlik.com/t5/QlikView/Dreadful-data-structure-ideas-sought-to-improve/m-p/972472#M980462 <HTML><HEAD></HEAD><BODY><P>try to</P><P></P><P>...</P><P>load buildings ....</P><P>left join</P><P>load rooms ....</P><P>left join</P><P>load floors...</P><P>...</P><P></P><P>in this way you will have only one synt. key</P></BODY></HTML> Fri, 21 Aug 2015 13:50:06 GMT https://community.qlik.com/t5/QlikView/Dreadful-data-structure-ideas-sought-to-improve/m-p/972472#M980462 alexandros17 2015-08-21T13:50:06Z