topic hinding expressions in QlikView

hinding expressions

souadouert — Tue, 02 May 2017 11:11:52 GMT

Hello,

I have a pivot table, with 7 expressions the 7th expression is calculated by the 6 other expressions, and I want to hide them how

thank y

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 11:15:11 GMT

You will need to use a one time Macro to make the column width = 0

Pivot Column Width to Zero

Re: hinding expressions

souadouert — Tue, 02 May 2017 12:38:47 GMT

Hi sunny;

i added the macro but i dont know how and where i call this macro

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 12:45:54 GMT

Use a button object to use the Macro. This has to be done only one time for each column. After that you can remove the macro and delete the button

Re: hinding expressions

souadouert — Tue, 02 May 2017 12:57:31 GMT

sunny i have this issue

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 13:02:17 GMT

What is the issue? Sorry not sure I understand

Re: hinding expressions

souadouert — Tue, 02 May 2017 13:06:25 GMT

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 13:09:50 GMT

What is the exact Macro you used? Can you paste it here?

Re: hinding expressions

souadouert — Tue, 02 May 2017 13:17:04 GMT

sub Squeeze

call HideColumn("CH121",5)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 13:33:04 GMT

Check out the attachment

Re: hinding expressions

sunny_talwar — Tue, 02 May 2017 13:36:42 GMT

I used this

SUB Squeeze

CALL HideColumn("CH02", 3)

END SUB

PRIVATE SUB HideColumn(ch, n)

SET ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

END SUB

See how the two columns are almost hidden in the below table.... I used two buttons just to show that in the sample app