topic Re: How to flexible change the TABLE's structure? in QlikView https://community.qlik.com/t5/QlikView/How-to-flexible-change-the-TABLE-s-structure/m-p/433065#M161374 <HTML><HEAD></HEAD><BODY><P>Hi friends，</P><P>Who can help me about this question? Thanks again.</P></BODY></HTML> Tue, 22 Jan 2013 01:02:39 GMT 2013-01-22T01:02:39Z How to flexible change the TABLE's structure? https://community.qlik.com/t5/QlikView/How-to-flexible-change-the-TABLE-s-structure/m-p/433064#M161373 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P></P><P>I have a pivot table. I want the users custom the stucture of the table. I draw 4 tables like below.</P><P>These tables have 4 dimensions and 1 expression. </P><P></P><P>Tab1 has all dimensions and expression on the top.</P><P>Tab2 has 2 dimensions(Year and YearMonth) on the top and 1 denmension in the "left".</P><P>Tab3 has 1 on the top and 2 in the left.</P><P></P><P>I want to change the pivot into these different structures with MACRO. And I know a property named cp.TableProperties.NumberOfLeftDimensions can control Number Of Left Dimensions. I can get tab1(set NumberOfLeftDimensions=0) and tab4 (set NumberOfLeftDimensions=3). But I don't know how to get tab2 and tab3.&nbsp; I think if there is some other property which can help me to solve the problem?</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>...<IMG __jive_id="30750" class="jive-image-thumbnail jive-image" onclick="" alt="qv.JPG" src="https://community.qlik.com/legacyfs/online/30750_qv.JPG" width="450" /></P></BODY></HTML> Fri, 18 Jan 2013 03:31:56 GMT https://community.qlik.com/t5/QlikView/How-to-flexible-change-the-TABLE-s-structure/m-p/433064#M161373 2013-01-18T03:31:56Z Re: How to flexible change the TABLE's structure? https://community.qlik.com/t5/QlikView/How-to-flexible-change-the-TABLE-s-structure/m-p/433065#M161374 <HTML><HEAD></HEAD><BODY><P>Hi friends，</P><P>Who can help me about this question? Thanks again.</P></BODY></HTML> Tue, 22 Jan 2013 01:02:39 GMT https://community.qlik.com/t5/QlikView/How-to-flexible-change-the-TABLE-s-structure/m-p/433065#M161374 2013-01-22T01:02:39Z