topic Re: Column Number pivot table in QlikView

Column Number pivot table

emteam162 — Wed, 10 Oct 2012 15:53:53 GMT

Hi,

I want know number of column the pivot table.

exist a function that allows to know the number column.

Many thanks for your help.

Best Regards,

Emteam

Gysbert_Wassenaar — Wed, 10 Oct 2012 18:20:41 GMT

yes, you can do this with a macro:

sub ShowColumns()

set obj = ActiveDocument.GetSheetObject( "CH02" )

w = obj.GetColumnCount

msgbox(w)

end sub

Wed, 10 Oct 2012 19:12:05 GMT

Hi,

Thank you for reply.

My idea is when you make a selection in pivot table (mybe you can know the location clicked at the pivot table).

I can't implement ColumnNo()???

Can you attach Example with : Pivot Table and ColumnNo(),dimensionality()

Many thanks for your help.

Best Regards,

Emteam

Gysbert_Wassenaar — Wed, 10 Oct 2012 19:19:28 GMT

As far as I know there is no way to get the column and row of the cell of the pivot table when you click on the cell.

emteam162 — Wed, 10 Oct 2012 22:15:46 GMT

Hi,

ok i see, thank you.

Best Regards,

Emteam

Gysbert_Wassenaar — Thu, 11 Oct 2012 08:01:06 GMT

Could you mark this as answered? That makes the answer easier to find for others with the same question. Thanks.