topic Re: Using Multiple Fields as Single Dimension on 3D Pie Chart in QlikView https://community.qlik.com/t5/QlikView/Using-Multiple-Fields-as-Single-Dimension-on-3D-Pie-Chart/m-p/425906#M570169 <HTML><HEAD></HEAD><BODY><P>So I was able to solve my problem by creating a table joined to the original table that housed the ID of all projects, a generic RAGStatus to house Red, Amber, Green values and a RAGType field.&nbsp; I loaded each field to the table using concatenation and changing RAGType based on the type of RAG I was loading. Then I used the RAGType field as my x-axis dimension.&nbsp; Hopefully that helps anyone else who may run across this problem.&nbsp; Appreciate anyone who may have looked into this.</P></BODY></HTML> Thu, 20 Sep 2012 13:29:25 GMT Anonymous 2012-09-20T13:29:25Z Using Multiple Fields as Single Dimension on 3D Pie Chart https://community.qlik.com/t5/QlikView/Using-Multiple-Fields-as-Single-Dimension-on-3D-Pie-Chart/m-p/425905#M570168 <HTML><HEAD></HEAD><BODY><P>Hi all, so I've looked around these forums for the past day but I can't seem to find a solution to what I'm trying to do.&nbsp; The problem I'm trying to solve is that in the 3D pie chart I created, I want my data broken down by Business Unit then using four other fields as a single dimension.&nbsp; I've attached a sample application that gives you an idea of what my data model looks like.&nbsp; I've also attached a mockup that should give you an idea of what I want the final chart to look like.&nbsp; What am I missing to make these four field names as the x-axis dimension with the count of all projects (uniquely identified by ID in the sample app) as the breakdown of the pie charts? Any help is greatly appreciated, thanks!</P></BODY></HTML> Thu, 20 Sep 2012 13:03:22 GMT https://community.qlik.com/t5/QlikView/Using-Multiple-Fields-as-Single-Dimension-on-3D-Pie-Chart/m-p/425905#M570168 Anonymous 2012-09-20T13:03:22Z Re: Using Multiple Fields as Single Dimension on 3D Pie Chart https://community.qlik.com/t5/QlikView/Using-Multiple-Fields-as-Single-Dimension-on-3D-Pie-Chart/m-p/425906#M570169 <HTML><HEAD></HEAD><BODY><P>So I was able to solve my problem by creating a table joined to the original table that housed the ID of all projects, a generic RAGStatus to house Red, Amber, Green values and a RAGType field.&nbsp; I loaded each field to the table using concatenation and changing RAGType based on the type of RAG I was loading. Then I used the RAGType field as my x-axis dimension.&nbsp; Hopefully that helps anyone else who may run across this problem.&nbsp; Appreciate anyone who may have looked into this.</P></BODY></HTML> Thu, 20 Sep 2012 13:29:25 GMT https://community.qlik.com/t5/QlikView/Using-Multiple-Fields-as-Single-Dimension-on-3D-Pie-Chart/m-p/425906#M570169 Anonymous 2012-09-20T13:29:25Z