Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

cabhijit
Valued Contributor

Hiding Column In Table Box

Hi,

I've a requirement of downloading table box data into the csv file.

i'm doing this using macro. it is working fine.

but, there is one column is table box which need not to be downloaded to csv file,but this column need to be present in the tablebox to get unique records.

so, i want to hide this column so that it will not appear in downloaded data.

i've tried below macro to set column width of that particular column to 0:

tbp.Layout.ColLayouts.Item(0).ColWidth = 0

but it is not allowing me to set ColWidth to 0, and shows below error:

“The call of the procedure or the argument is illegal.”

I really got stuck at this problem.

In straight table we can hide column, but i can't use straight table because it gets heavy on bulk data and

performance of my application (specially CSV download functionality) is getting hampered.

Tags (2)
1 Reply
Not applicable

Hiding Column In Table Box

Can you not just make the table box a chart type of table and have that as an expression and then hide the expression?