topic How to represent table in trellis style format?? in QlikView https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308826#M585337 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In the figure below i need to show table in this format in qlikview. tables are separated by there location. Clestica Monterry, Flextronics and wistron are the locations.. </P><P></P><P>Please help me out to how would i able to show table like below format in qlikview... i am not able to find any clue..</P><P></P><P>Thanks.</P><P></P><P><IMG alt="table.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/6873_table.JPG" width="450" /></P></BODY></HTML> Tue, 30 Aug 2011 05:39:50 GMT sushil353 2011-08-30T05:39:50Z How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308826#M585337 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In the figure below i need to show table in this format in qlikview. tables are separated by there location. Clestica Monterry, Flextronics and wistron are the locations.. </P><P></P><P>Please help me out to how would i able to show table like below format in qlikview... i am not able to find any clue..</P><P></P><P>Thanks.</P><P></P><P><IMG alt="table.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/6873_table.JPG" width="450" /></P></BODY></HTML> Tue, 30 Aug 2011 05:39:50 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308826#M585337 sushil353 2011-08-30T05:39:50Z How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308827#M585338 <HTML><HEAD></HEAD><BODY><P>HI Sushil,</P><P></P><P>If you want this representation, you must choose the Pivot Table chart, and then select "Location", "Operation", "Test" and "Measurement" in dimensions. </P><P></P><P>Your expressions will be the "Total Quantity", "%Impact" and "%NDF, NDR".</P><P></P><P>Regards,</P><P></P><P>Amand</P></BODY></HTML> Tue, 30 Aug 2011 07:29:41 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308827#M585338 2011-08-30T07:29:41Z How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308828#M585339 <HTML><HEAD></HEAD><BODY><P>but the main problem is with location.. which is out side of each sub table?</P><P></P><P>Thanks for your reply</P></BODY></HTML> Tue, 30 Aug 2011 07:37:43 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308828#M585339 sushil353 2011-08-30T07:37:43Z How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308829#M585340 <HTML><HEAD></HEAD><BODY><P>I think you must add a new table in the data model with your locations.</P><P></P><P>Can you attach your qvw file please ?</P><P></P><P>Regards,</P><P></P><P>Amand</P></BODY></HTML> Tue, 30 Aug 2011 07:41:26 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308829#M585340 2011-08-30T07:41:26Z Re: How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308830#M585341 <HTML><HEAD></HEAD><BODY><P>Please find the attached QVW.. i want to generate table separately for each location or selected locations</P><P></P><P></P><P>Thanks</P></BODY></HTML> Tue, 30 Aug 2011 07:50:10 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308830#M585341 sushil353 2011-08-30T07:50:10Z Re: How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308831#M585342 <HTML><HEAD></HEAD><BODY><P>Sushil,</P><P></P><P>See the attached file. I make an example with the set analysis.</P><P></P><P>Regards,</P><P></P><P>Amand</P></BODY></HTML> Tue, 30 Aug 2011 08:46:00 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308831#M585342 2011-08-30T08:46:00Z Re: How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308832#M585343 <HTML><HEAD></HEAD><BODY><P>Hi Thanks Amand..</P><P></P><P></P><P>Is it possible to do it automaticaly... means instead of creating each table manually it will populate according to the selected location</P></BODY></HTML> Tue, 30 Aug 2011 08:58:23 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308832#M585343 sushil353 2011-08-30T08:58:23Z Re: How to represent table in trellis style format?? https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308833#M585344 <HTML><HEAD></HEAD><BODY><P>Sushil,</P><P></P><P>You can do this with a macro, which can generate your charts automatically. See the API Guide in your QlikView installation directory.</P><P></P><P>Why do you want this representation ? For a report ?</P><P></P><P>Regards,</P><P></P><P>Amand</P></BODY></HTML> Tue, 30 Aug 2011 09:31:40 GMT https://community.qlik.com/t5/QlikView/How-to-represent-table-in-trellis-style-format/m-p/308833#M585344 2011-08-30T09:31:40Z