Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color in table box

Hi All,

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

Thanks

5 Replies
Anonymous
Not applicable
Author

Hi Kamal,

Click on the Design Grid icon :

Capture.PNG.png

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

Hope this helps,

Quentin

Not applicable
Author

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
Master III
Master III

Means you are doing it through  macro

Not applicable
Author

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

Not applicable
Author

yes.. I want to do it in macro