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
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashwinyp
Contributor III
Contributor III

Conditionally format Totals function in Straight table

I want to apply conditional formatting on the Totals function of one column in a Straight table.

BinExpectedActualExpected%Actual%log(Actual% / Expected%) * (Actual% - Expected%)
1353325%20%0.01
2617444%45%0.00
3253618%22%0.01
4192014%12%0.00
     0.02

 

This is how my table looks. The total function here is 0.02 and I would like to change its text/background color based on an "If" condition, like if(total>0.25, red(), green()). But I'm unable to do it. I have tried using dimensionality()=0 and rowNo()=0 but it does not work.

Can someone please help?

1 Reply
y_grynechko
Creator III
Creator III

Hey, it is not going to be easy to do but it is possible:

Capture.PNG

Script logic:

Capture1.PNG

Used if statement: 

Capture3.PNG