Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oscargm_bi
Contributor III
Contributor III

Problems with color text in pivot table

Hi all,

I have this expression in a measure of a pivot table:  if(avg([Importe Est. Moneda CTV]) > 44000,'red','green') that makes if the average of the "importe..." its > 44.000 turn red the value o green if its not. 

Everything works fine, but when I add the Totals of the dimension, the data always turn in red without fulfill the conditional.

Attach there is a image of the problem.

 

Thanks in advance.

 

Regards

Labels (3)
1 Reply
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

hello,

the total is correct?

I think you gotta to specify the dimension which you want to calcul the average condition  avg(total <dim1,dim2,...>KPI)

Bye