Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

1 Reply
Jsaintmaxent
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