Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
solomonadjei
Contributor III
Contributor III

Colour not working with calculated field

Could someone please tell what I am doing wrong. Based on the yellow highlighted figures, I assumed the red field figures should be green but it not.  Thanks

ColourColour

 

7 Replies
jaumecf23
Creator III
Creator III

You're applying the colours to the Expression and this is why the last column (Actual Trust Spend) is appearing in Red. You need to apply this formula in the Dimensions sheet to the affected dimension. 

solomonadjei
Contributor III
Contributor III
Author

Thanks Jaumecf23,
I have tried it in the dimentions sheet and I get the same asnwer.

solomonadjei
Contributor III
Contributor III
Author

Both left and right figures highlighted in yellow are the same and I assume the red fields should be GREEN but it’s not..

not correct.PNG

 

jaumecf23
Creator III
Creator III

Here you have an screenshot where you need to add your formula:

Captura.PNG

Is it possible for you to attach the qvw file? Because it should work.

solomonadjei
Contributor III
Contributor III
Author

This is what I get, Maybe my expression is incorrect.

111.PNG

 

jduenyas
Specialist
Specialist

You are comparing value with text.

Change the 'Actual Trust Spend' to the name of the calculated field [Actual Trust Spend].

 

solomonadjei
Contributor III
Contributor III
Author

Thanks Jduenyas,
I have tried your suggestion and it keeps hightlight in RE. becaused its not a field name.
It's a Label name