Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to flexible change the TABLE's structure?

Hello,

I have a pivot table. I want the users custom the stucture of the table. I draw 4 tables like below.

These tables have 4 dimensions and 1 expression.

Tab1 has all dimensions and expression on the top.

Tab2 has 2 dimensions(Year and YearMonth) on the top and 1 denmension in the "left".

Tab3 has 1 on the top and 2 in the left.

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.  I think if there is some other property which can help me to solve the problem?

Thanks

...qv.JPG

1 Reply
Not applicable
Author

Hi friends,

Who can help me about this question? Thanks again.