Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Not applicable

Color in table box

Hi All,

Does anyone have example of script to change the color of table box ?


Tags (2)
5 Replies

Re: Color in table box

Hi Kamal,

Click on the Design Grid icon :


Then, right click on your table box and choose Custom Format Cell.

Hope this helps,


Not applicable

Re: Color in table box

Thanks Bruno, I am able to do it in menu, How to do it in the script .. I am trying like

set TB = ActiveDocument.GetSheetObject("TB01")

If TB.GetrowCount > 1 then
set prop = TB.GetProperties
prop.Layout.Frame.Color.PrimaryCol.Col = RGB(0,0,0)

This does not work

Honored Contributor III

Re: Color in table box

Means you are doing it through  macro

Not applicable

Re: Color in table box

Hi kamal ,

In UserPreferences -> design -> check Always show design Grid Menus

and right click on any cell value of Table Box, Straight table and Pivot table..

U can have one Option RightClick -> Custom format Cell

Through that U can change color and font of Cell value..



Not applicable

Re: Color in table box

yes.. I want to do it in macro