Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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