Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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,


4 Replies
Champion III
Champion III

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.


Not applicable

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

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

thanks for help

Champion III
Champion III

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

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


Beau Brenno