Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Highlighted
Not applicable

Color in table box

Hi All,

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

Thanks

Tags (2)
5 Replies
quentin_bruno
Contributor

Re: Color in table box

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

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

Regards,

koti

Not applicable

Re: Color in table box

yes.. I want to do it in macro