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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.