topic Pivot Table Issues in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Issues/m-p/879780#M307066 <HTML><HEAD></HEAD><BODY><P>I'm currently trying to develope table and there are two routes to the solution,</P><P></P><P>What we want to is take a list of projects display the resources working on said project, the show the projects these resources are assigned to.&nbsp; Since the the Dimension for the projects can only be loaded once, we can't use the in both instances, so I created an expression to display the project names but this expression won't pivot so I just get the name project furthest to the left.</P><P></P><P>The other option would be a partially disconnected table in which the user would select a project and on the seperate tablwe the resources and the other projects they are allocated to would display.&nbsp; The issue currently is that selecting the one porject narrows the results, hence the need to partiall detach the table.</P><P></P><P>Hope someone can help.</P></BODY></HTML> Wed, 08 Apr 2015 18:21:03 GMT 2015-04-08T18:21:03Z Pivot Table Issues https://community.qlik.com/t5/QlikView/Pivot-Table-Issues/m-p/879780#M307066 <HTML><HEAD></HEAD><BODY><P>I'm currently trying to develope table and there are two routes to the solution,</P><P></P><P>What we want to is take a list of projects display the resources working on said project, the show the projects these resources are assigned to.&nbsp; Since the the Dimension for the projects can only be loaded once, we can't use the in both instances, so I created an expression to display the project names but this expression won't pivot so I just get the name project furthest to the left.</P><P></P><P>The other option would be a partially disconnected table in which the user would select a project and on the seperate tablwe the resources and the other projects they are allocated to would display.&nbsp; The issue currently is that selecting the one porject narrows the results, hence the need to partiall detach the table.</P><P></P><P>Hope someone can help.</P></BODY></HTML> Wed, 08 Apr 2015 18:21:03 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Issues/m-p/879780#M307066 2015-04-08T18:21:03Z Re: Pivot Table Issues https://community.qlik.com/t5/QlikView/Pivot-Table-Issues/m-p/879781#M307067 <HTML><HEAD></HEAD><BODY><P>Could you perhaps provide a simple example QVW file to make it easier to see what you are trying to accomplish?</P></BODY></HTML> Wed, 08 Apr 2015 23:57:21 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Issues/m-p/879781#M307067 ToniKautto 2015-04-08T23:57:21Z