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

have a column with a number of row in a pivot table??

hi all.

          I wan't use macro,for example:

     

rem ***获得报表行数和列数***

sub getRowColumn

   

    set mytext = ActiveDocument.GetSheetObject("TX131")

    prop = mytext.GetProperties

   

    set table = ActiveDocument.GetSheetObject("CH06")

    count=table.GetRowCount-1

    column=table.GetColumnCount

    prop.Layout.Text.v = "报表:"&count&"行  "&column&"列"

    mytext.SetProperties prop

   

end sub

Is there a way  to have a column with a number of row in a pivot table ? Somebody can help me? thanks!

0 Replies