QlikView Integrations

[#1]

Hi All,

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

Thanks

[quentin_bruno]

Hi Kamal,

Click on the Design Grid icon :

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

Hope this helps,

Quentin

[#3]

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]

Means you are doing it through  macro

[#5]

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

[#6]

yes.. I want to do it in macro