topic Sections/Breaks In a Sheet in QlikView https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147967#M26335 <HTML><HEAD></HEAD><BODY><P>I have a Pivot Table which has a 'Region' along the Top (AMERICAS, EMEA, APAC).</P><P></P><P>Does anyone know how this can be displayed whereby i have a separate table per region displayed one below each other?</P><P></P></BODY></HTML> Mon, 29 Jun 2009 22:17:53 GMT 2009-06-29T22:17:53Z Sections/Breaks In a Sheet https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147967#M26335 <HTML><HEAD></HEAD><BODY><P>I have a Pivot Table which has a 'Region' along the Top (AMERICAS, EMEA, APAC).</P><P></P><P>Does anyone know how this can be displayed whereby i have a separate table per region displayed one below each other?</P><P></P></BODY></HTML> Mon, 29 Jun 2009 22:17:53 GMT https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147967#M26335 2009-06-29T22:17:53Z Sections/Breaks In a Sheet https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147968#M26336 <HTML><HEAD></HEAD><BODY><P>Have a calculated dimension in the table that returns something if the row is what you are after else returns null such as if (Region= 'AMERICAS', Region) then check 'suppress when value is null'.</P><P>You can then hide the column if needs be by setting its width to zero.</P><P></P></BODY></HTML> Mon, 29 Jun 2009 22:26:31 GMT https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147968#M26336 2009-06-29T22:26:31Z Sections/Breaks In a Sheet https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147969#M26337 <HTML><HEAD></HEAD><BODY><P>That's Perfect Gordon. Works a treat.</P><P>Next challenge is to do the same thing with a Pi Chart I want to display alongside the table. Thanks for your help!</P></BODY></HTML> Mon, 29 Jun 2009 22:39:25 GMT https://community.qlik.com/t5/QlikView/Sections-Breaks-In-a-Sheet/m-p/147969#M26337 2009-06-29T22:39:25Z