topic Loop Through St.Table to get the hidden column values through macro in QlikView

Loop Through St.Table to get the hidden column values through macro

sarathi_pm — Fri, 28 Feb 2014 13:24:53 GMT

Hi,

I want to loop through a straight table where in i want to get the values of the hidden columns as well? Is there any way that i can do this?

As of now the below code loops through the table's column, but fetches only the visible column data.

set table = ActiveDocument.GetSheetObject("CH01")

for RowIter = 0 to table.GetRowCount-1
for ColIter =0 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)

msgbox cell.Text

Any suggestion pls.

Thanks

Sarathi

Re: Loop Through St.Table to get the hidden column values through macro

Anonymous — Fri, 28 Feb 2014 14:15:36 GMT

Yes, this macro can't read hidden columns.

Can you just squeeze the column width to 0 instead of hiding it? Another option, make it reasonably narrow, and use font color same as background (e.g. white on white).

Yet another possible solution - un-hide column in the beginning of the macro and hide at the end.

Regards,

Michael

Re: Loop Through St.Table to get the hidden column values through macro

sarathi_pm — Sat, 01 Mar 2014 06:23:23 GMT

Hi Michael.

Thanks for spending time and helping me.

The work around looks good.

Thanks

sarathi