Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to change the background color of the column total?

Hi,

I need help to change the background  color of the column/sub total.

I was comparing  agent's performance against the monthly target per agent. The background color is green if its above the target and black otherwise.

But the background color of column/sub total also changed. It should only be changed  if TOTAL values >= Team target  (NOT  if  Total Values >= AM target)

My table looks like this.

Monthly targets.png

Thanks in advance!

5 Replies
Not applicable

Re: How to change the background color of the column total?

MENU-->SETTING-->DESIGN-->CHECK ON ALWAYS SHOW DESIGN MENU

THEN

Right click on the ANY DATA OF CHART(OBJECT) and select Custom Format Cell from thepopup- menu.

If you don't have this option, you can enable it via Settings|User Preferences, Tab Design, Always Show Design Menu Items

Not applicable

Re: How to change the background color of the column total?

It didnt work.

Not applicable

Re: How to change the background color of the column total?

I use the the attached  formula to change the attribute.

Not applicable

Re: How to change the background color of the column total?

But I dont want the background for totals

Not applicable

Re: How to change the background color of the column total?

Hi,

I haven't understood your problem clearly. I would be good if you upload a qvw with dummy data to explain your scenario in detail.

One thing I can think of as of now is try using Total keyword into your background color formula like this:

=if(Type2 = '1st Time yearly' AND SUM(TOTAL Volume) >= ROUND(S_Svolume_Target/7)*0.28, green(200),.....

The Total will calculate total disregarding all the current dimension. If you want to apply any dimension you can use <> key word to apply over Total. like SUM(TOTAL <Agent> Volume)  so now total volume will be calculated as per Agent disregarding other dimensions if you have any.

Hope this help.

Regards,

Anosh Nathaniel

Community Browser