topic Re: How to change chart or table background color / text format through variables in QlikView

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

anat — Fri, 20 Nov 2020 18:02:30 GMT

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

..........

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

Anonymous — Fri, 17 Apr 2015 12:30:10 GMT

Hi Bab,

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

-Jay

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

anat — Fri, 17 Apr 2015 12:34:01 GMT

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

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

simenkg — Fri, 17 Apr 2015 12:35:34 GMT

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.

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

simenkg — Fri, 17 Apr 2015 12:36:11 GMT

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

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

jpenuliar — Fri, 17 Apr 2015 12:36:12 GMT

Try the Format Painter technique

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

Fri, 17 Apr 2015 12:37:10 GMT

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

QlikView

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

anat — Fri, 17 Apr 2015 12:50:08 GMT

Thanks Simen,

This method is working for all objects except chart.