Skip to main content

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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
quentin_bruno
Creator
Creator

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