topic Re: Unhide a column that is hidden in QlikView

Unhide a column that is hidden

Tue, 18 Aug 2015 22:26:14 GMT

Hi all,

I used a simple macro to hide a column in a pivot table. However, I can't figure out how to UNhide it!

What's the macro code that will reverse this?

Thanks!

Here's the macro code I used:

sub Squeeze

call HideColumn("CH25", 1)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

Re: Unhide a column that is hidden

ramoncova06 — Tue, 18 Aug 2015 22:41:58 GMT

not sure why you would use a macro when you can use conditional to do the same thing, unless you are exporting data with the marco

Re: Unhide a column that is hidden

Tue, 18 Aug 2015 22:45:45 GMT

Ramon,

I appreciate the response. Unfortunately, it's not helpful for two reasons:

1) You didn't answer my question. I didn't ask for a value assessment.

2) I'm a beginner and I don't know what I'm doing. You offer an alternative without explaining it.

Thanks,

Sam

Re: Unhide a column that is hidden

rwunderlich — Tue, 18 Aug 2015 23:24:16 GMT

Hi Sam,

I'll wade in here with a value assessment. Try not to use a macro. Macros can be very problematic. You'll find many macros on this forum (many written by myself) that I wish could be deleted because there are better ways to do things with the current version.

Welcome to QlikView. We come from many different languages and cultures on this forum, and communication is not always perfectly smooth. Please be gentle on the forums and assume the best intentions and professional demeanor from all posters. I take Ramon's response as asking a helpful clarifying question.

A better alternative, if it will give you the desired results, is to use the Expression or Dimensional conditional property to suppress the column. If the condition is false, the column will not exist in the table. This may not be what you want if you need the column to form rows or export data. Let us know if you want more info on this option.

If you need to use a macro, the second parameter of SetPixWidth is the column width. You are setting it to 0 to hide the column. I suspect if you set it to a number greater then zero your column will be visible.

Be aware that your macro may not work if deployed to the QlikView Server.

-Rob

Re: Unhide a column that is hidden

Wed, 19 Aug 2015 00:49:41 GMT

Thanks for the background, Rob, and the explanation.