topic Recreating table with unorthodox structure in QlikView https://community.qlik.com/t5/QlikView/Recreating-table-with-unorthodox-structure/m-p/451509#M1156921 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>The table&nbsp; I'm attempting to build for the client has a pretty unorthodox layout. I'd like to keep to the original format, but don't know if this is possible in a Qlikview table.</P><P></P><P><IMG __jive_id="33692" class="jive-image-thumbnail jive-image" onclick="" alt="table_mockup.JPG" src="https://community.qlik.com/legacyfs/online/33692_table_mockup.JPG" width="450" /></P><P></P><P>I hope the picture shows clearly.</P><P>The four different rows could be covered by four expressions, that is simple enough. </P><P>Now. The first column is usually just one number copied from the first row. The second column is the actual expression result. The third column is the quotient of the two - a percentage of the set.</P><P>Does anyone have any ideas how to recreate this chart?</P></BODY></HTML> Tue, 19 Feb 2013 18:40:12 GMT 2013-02-19T18:40:12Z Recreating table with unorthodox structure https://community.qlik.com/t5/QlikView/Recreating-table-with-unorthodox-structure/m-p/451509#M1156921 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>The table&nbsp; I'm attempting to build for the client has a pretty unorthodox layout. I'd like to keep to the original format, but don't know if this is possible in a Qlikview table.</P><P></P><P><IMG __jive_id="33692" class="jive-image-thumbnail jive-image" onclick="" alt="table_mockup.JPG" src="https://community.qlik.com/legacyfs/online/33692_table_mockup.JPG" width="450" /></P><P></P><P>I hope the picture shows clearly.</P><P>The four different rows could be covered by four expressions, that is simple enough. </P><P>Now. The first column is usually just one number copied from the first row. The second column is the actual expression result. The third column is the quotient of the two - a percentage of the set.</P><P>Does anyone have any ideas how to recreate this chart?</P></BODY></HTML> Tue, 19 Feb 2013 18:40:12 GMT https://community.qlik.com/t5/QlikView/Recreating-table-with-unorthodox-structure/m-p/451509#M1156921 2013-02-19T18:40:12Z Re: Recreating table with unorthodox structure https://community.qlik.com/t5/QlikView/Recreating-table-with-unorthodox-structure/m-p/451510#M1156922 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think this could be achieved using set analysis for the first and third columns.</P><P></P><P>You want to post some sample data?</P><P></P><P>Joe</P></BODY></HTML> Fri, 22 Feb 2013 17:16:21 GMT https://community.qlik.com/t5/QlikView/Recreating-table-with-unorthodox-structure/m-p/451510#M1156922 mazacini 2013-02-22T17:16:21Z