topic Re: Export straight table with hidden column in QlikView

Export straight table with hidden column

sibin_jacob — Mon, 04 Feb 2013 06:01:35 GMT

Hi,

Is it possible to export straight table with hidden column?

Is this possible to achieve this functionality using macro?

Thanks,

Sibin Jacob.C

Mon, 04 Feb 2013 12:30:47 GMT

yes

macro :

-unhide column

-export

-hide column

sibin_jacob — Mon, 11 Feb 2013 11:49:04 GMT

Thanks Pari... Its helped me to solve the issue...

Tue, 22 Oct 2013 09:01:09 GMT

Hi, may u explain me how?

i tried :

set obj = ActiveDocument.GetSheetObject("CH02")

obj.Unhide

obj.SendToExcel

but it doesn't work

sibin_jacob — Wed, 23 Oct 2013 09:22:50 GMT

Hi simone,

Below are the steps to export straight table with hidden columns.

1. create a new variable (vTest).

2. create new text object ( add text as Export)

3. add a action into that text object (

a. use set variable trigger -> set the variable value into 1

b. user run macro trigger)

4. In the straight table, show/enable the hidden expression when the variable value is 1

5.Use the macro to export the straight table

6. At the end of the macro, change the variable value into 0.

below is the line of macro for change the variable value.

ActiveDocument.Variables("vTest").SetContent 0,true

I hope this helps! Let me know if you need additional details.

Thanks,

Sibin Jacob. C