topic Re: Problem with trellis pie charts in QlikView https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381734#M571393 <HTML><HEAD></HEAD><BODY><P>Make sure "Enable Secondary Trellis Dimension" is unchecked.</P></BODY></HTML> Wed, 29 Aug 2012 09:50:08 GMT kji 2012-08-29T09:50:08Z Problem with trellis pie charts https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381733#M571392 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I'm creating a trellis chart for the first time. </P><P></P><P>I want a pie chart "multiplied" with the number of product categories I have so that's an obvious dimension. But then I want to calculate my sales on basis of Product Type (that can be either "1" or "0") and have a slice representing each Product Type.</P><P></P><P>So what I do is the following:</P><P><BR />DIMENSIONS</P><P>Category</P><P>ProductType</P><P></P><P>EXPRESSION</P><P>=sum(Sales)</P><P></P><P>But, when enabling Trellis and "Second Dimension" I get this weird result:</P><P></P><P><IMG __jive_id="20862" class="jive-image-thumbnail jive-image" onclick="" alt="trellis.png" src="https://community.qlik.com/legacyfs/online/20862_trellis.png" width="450" /></P><P></P><P>0,1 = ProductType </P><P>00,1A,1E,etc... = Category</P><P></P><P>How do I get the result I want?</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 29 Aug 2012 08:39:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381733#M571392 2012-08-29T08:39:33Z Re: Problem with trellis pie charts https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381734#M571393 <HTML><HEAD></HEAD><BODY><P>Make sure "Enable Secondary Trellis Dimension" is unchecked.</P></BODY></HTML> Wed, 29 Aug 2012 09:50:08 GMT https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381734#M571393 kji 2012-08-29T09:50:08Z Re: Problem with trellis pie charts https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381735#M571395 <HTML><HEAD></HEAD><BODY><P> If I understand correctly you sould change the order of you dimensions and uncheck Secondary trllis dimension.</P></BODY></HTML> Wed, 29 Aug 2012 09:59:18 GMT https://community.qlik.com/t5/QlikView/Problem-with-trellis-pie-charts/m-p/381735#M571395 whiteline 2012-08-29T09:59:18Z