topic Re: Color in table box in QlikView

Color in table box

Mon, 26 Jan 2026 16:26:21 GMT

Hi All,

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

Thanks

Anonymous — Fri, 29 Nov 2013 11:22:48 GMT

Hi Kamal,

Click on the Design Grid icon :

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

Hope this helps,

Quentin

Fri, 29 Nov 2013 11:39:19 GMT

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")
msgbox(TB.GetrowCount)

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

This does not work

sujeetsingh — Fri, 29 Nov 2013 11:45:51 GMT

Means you are doing it through macro

Fri, 29 Nov 2013 11:49:56 GMT

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..

Regards,

koti

Fri, 29 Nov 2013 12:11:01 GMT

yes.. I want to do it in macro