topic Re: hide row in pivot table by macro in QlikView

hide row in pivot table by macro

Tue, 26 Mar 2013 08:30:05 GMT

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

Re: hide row in pivot table by macro

Anonymous — Tue, 26 Mar 2013 15:58:26 GMT

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

Re: hide row in pivot table by macro

Thu, 18 Apr 2013 15:53:13 GMT

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

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

thanks for help

Re: hide row in pivot table by macro

Anonymous — Thu, 18 Apr 2013 17:14:25 GMT

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)

Re: hide row in pivot table by macro

Mon, 12 May 2014 18:36:51 GMT

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

Thanks,

Beau Brenno