Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hide row in pivot table by macro

Hi all,

Is there the possibility to hide a row in a pivot table like the column?

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

I try to use SetPixHeight but with no result.

Anyone can help me?

Thanks all in advance,

Davide

4 Replies
Anonymous
Not applicable
Author

Rows in tables as a rule are defined by dimension values.  If you want to hide a row where your dimension D has value 'ZZZ', you can use calculated dimension, something like this:
aggr(only({<D-={'ZZZ'}>} D),D)
and suppress when value is null.
If is not what you want, explain what "hiding a row" means in your case.

Regards,
Michael

Not applicable
Author

I want to hide the header row in a pivot table.

Is there a solution? (I think throught a macro...)

thanks for help

Anonymous
Not applicable
Author

The only solution I can think of for a pivot table header is to set the labels of all dimensions and expressions to ' ' (one space).  Header row is not removed, it only looks blank.

(There is "suppress header" in straight table)

Not applicable
Author

Davide - Did you find a solution for this?  I am dealing with a similar issue.

Thanks,

Beau Brenno