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: 
anat
Master
Master

How to change chart or table background color / text format through variables

Team,

my application having around 20 charts(different charts) and 20 tables,i want to change charts background color and tables font & size.

for that i want to pass 1  variable to change color and 1 variable to change  font without doing manually one  by one.if i pass variable value as a 10 then it should reflect all tables font size.

Regards

..........

7 Replies
Anonymous
Not applicable

Hi Bab,

  Can you tell us the need for this requirement, is user wants to change the background colors?

-Jay

anat
Master
Master
Author

Yes,for all tables client want to implement font as "Calibri" and size "10" and background colors also

simenkg
Specialist
Specialist

if you create a variable

let vChartColor = RGB(100,100,100);

Under the color-settings you are trying to change, select Calculated and write: $(vChartColor) in the box. Do this for all your charts.

then if you want to change the colors of all the charts simply change the vChartColor-variable and they will all update with new colors.

simenkg
Specialist
Specialist

The fonts can be change under document properties -> Fonts. There you can apply it to all objects.

jpenuliar
Partner - Specialist III
Partner - Specialist III

Try the Format Painter technique

Not applicable

Look into this demo application in qlik. you might get an idea to implement user preferred colours and fonts.

QlikView

anat
Master
Master
Author

Thanks Simen,

This method is working for all objects except chart.