query data from a pivot table using a macro

ali_hijazi — Wed, 07 Sep 2011 13:46:30 GMT

Hello

I got a pivot table

is there a way to query data from this pivot table using a macro

the pivot table got only one row with data the rest show null in the expression

swuehl — Wed, 07 Sep 2011 15:19:01 GMT

You want the content of a pivot table's cell (like in your other post)?

So maybe like this (taken from the example and posted to your other post, too):

set table = ActiveDocument.GetSheetObject( "CH01" )

for RowIter = 0 to table.GetRowCount-1

for ColIter =0 to table.GetColumnCount-1

set cell = table.GetCell(RowIter,ColIter)

msgbox(cell.Text)

Regards,

Stefan

topic query data from a pivot table using a macro in QlikView