<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Pivot Tables Formats in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Pivot-Tables-Formats/m-p/223427#M75946</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am traying to set diferents length to pivot tables columns with the same dimension i.e. to the dimension "PERIOD" it would see like this&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 481pt; border-collapse: collapse;" width="638"&gt;&lt;COLGROUP&gt;&lt;COL style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;" width="215" /&gt;&lt;COL span="4" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70" /&gt;&lt;COL style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" width="73" /&gt;&lt;COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="width: 161pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="215"&gt;PERIOD&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2005&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2006&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2007&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2008&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 55pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="73"&gt;2009&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2010&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;"&gt;SALES&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1000"&gt;$1,000&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1200"&gt;$1,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1150"&gt;$1,150&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="2100"&gt;$2,100&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="3200"&gt;$3,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="850"&gt;$850&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;But in this moment QV set the same length to the diferents columns and I have not been able to change it. It looks like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 301pt; border-collapse: collapse;" width="399"&gt;&lt;COLGROUP&gt;&lt;COL span="7" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="width: 43pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="57"&gt;PEROD&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2005&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2006&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2007&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2008&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2009&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2010&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;"&gt;SALES&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1000"&gt;$1,000&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1200"&gt;$1,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1150"&gt;$1,150&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="2100"&gt;$2,100&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="3200"&gt;$3,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="850"&gt;$850&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;There is a way to do this or qv always set the same lenght to each columns in a Pivot Table?&lt;/P&gt;&lt;P&gt;I hope you can give a hand with this issue.&lt;/P&gt;&lt;P&gt;regards!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 15 Jul 2010 00:31:44 GMT</pubDate>
    <dc:creator />
    <dc:date>2010-07-15T00:31:44Z</dc:date>
    <item>
      <title>Pivot Tables Formats</title>
      <link>https://community.qlik.com/t5/QlikView/Pivot-Tables-Formats/m-p/223427#M75946</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am traying to set diferents length to pivot tables columns with the same dimension i.e. to the dimension "PERIOD" it would see like this&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 481pt; border-collapse: collapse;" width="638"&gt;&lt;COLGROUP&gt;&lt;COL style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;" width="215" /&gt;&lt;COL span="4" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70" /&gt;&lt;COL style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" width="73" /&gt;&lt;COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="width: 161pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="215"&gt;PERIOD&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2005&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2006&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2007&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2008&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 55pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="73"&gt;2009&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 53pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="70"&gt;2010&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;"&gt;SALES&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1000"&gt;$1,000&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1200"&gt;$1,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1150"&gt;$1,150&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="2100"&gt;$2,100&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="3200"&gt;$3,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="850"&gt;$850&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;But in this moment QV set the same length to the diferents columns and I have not been able to change it. It looks like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 301pt; border-collapse: collapse;" width="399"&gt;&lt;COLGROUP&gt;&lt;COL span="7" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57" /&gt;&lt;/COLGROUP&gt;&lt;TBODY&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="width: 43pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="57"&gt;PEROD&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2005&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2006&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2007&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2008&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2009&lt;/TD&gt;&lt;TD class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 43pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="57"&gt;2010&lt;/TD&gt;&lt;/TR&gt;&lt;TR height="17" style="height: 12.75pt;"&gt;&lt;TD class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;"&gt;SALES&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1000"&gt;$1,000&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1200"&gt;$1,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="1150"&gt;$1,150&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="2100"&gt;$2,100&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="3200"&gt;$3,200&lt;/TD&gt;&lt;TD align="right" class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;" num="850"&gt;$850&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;There is a way to do this or qv always set the same lenght to each columns in a Pivot Table?&lt;/P&gt;&lt;P&gt;I hope you can give a hand with this issue.&lt;/P&gt;&lt;P&gt;regards!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 15 Jul 2010 00:31:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Pivot-Tables-Formats/m-p/223427#M75946</guid>
      <dc:creator />
      <dc:date>2010-07-15T00:31:44Z</dc:date>
    </item>
  </channel>
</rss>

