Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dominikkeller
Contributor III
Contributor III

Dynamic Background in Totals on Straight Table

Hey Qlikkers,

i tried to build a Straight Table but the Totals Row kills me. For each Column i have an Expression how to format the Cell, but the Total Row does not really care about that. Any ideas?

Bildschirmfoto 2019-05-21 um 12.18.27.png

 

 

2 Solutions

Accepted Solutions
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

Your totals are an average so you can not assign a color from a condition in Sum(Betriebscheck.Data). Try something like:

if(Dimensionality() = 0,
	if(avg(Betriebscheck.Data)>0.9, green(255),
	if(avg(Betriebscheck.Data)>0.8, Yellow(255),
	if(avg(Betriebscheck.Data)>0.1, rgb(255,80,11))))
,
	if(sum(Betriebscheck.Data)>0.9,green(255),
	if(sum(Betriebscheck.Data)>0.8 ,Yellow(255),
	if(sum(Betriebscheck.Data)>0.1, rgb(255,80,11))))
)

if dimensionality()=0 then it is a "total" cell. Thus, I choose a color depending on cell type: I use AVG for total cells and SUM for regular ones.

Regards,

Jaime.

View solution in original post

Anonymous
Not applicable

for showing the value in total you are using average of rows

for the background color you are only using sum(Betriebscheck_Data)! BUT the sum(Betriebscheck_Data) for total is 3,497!!! and so green is the correct color
You may use avg instead of sum for the background color.
Or you define the colors in Visual Cues for the field Betriebscheck

View solution in original post

5 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

Could you share a sample of data so we can test?

Jaime

dominikkeller
Contributor III
Contributor III
Author

Hey Jaime,

here is a Test Version.

Thank you

jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

Your totals are an average so you can not assign a color from a condition in Sum(Betriebscheck.Data). Try something like:

if(Dimensionality() = 0,
	if(avg(Betriebscheck.Data)>0.9, green(255),
	if(avg(Betriebscheck.Data)>0.8, Yellow(255),
	if(avg(Betriebscheck.Data)>0.1, rgb(255,80,11))))
,
	if(sum(Betriebscheck.Data)>0.9,green(255),
	if(sum(Betriebscheck.Data)>0.8 ,Yellow(255),
	if(sum(Betriebscheck.Data)>0.1, rgb(255,80,11))))
)

if dimensionality()=0 then it is a "total" cell. Thus, I choose a color depending on cell type: I use AVG for total cells and SUM for regular ones.

Regards,

Jaime.

Anonymous
Not applicable

for showing the value in total you are using average of rows

for the background color you are only using sum(Betriebscheck_Data)! BUT the sum(Betriebscheck_Data) for total is 3,497!!! and so green is the correct color
You may use avg instead of sum for the background color.
Or you define the colors in Visual Cues for the field Betriebscheck

dominikkeller
Contributor III
Contributor III
Author

Work's perfect. Thank you