Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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. 

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

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

 

Highlighted
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.

Highlighted
Contributor III
Contributor III

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

111.PNG

 

Highlighted
Specialist
Specialist

You are comparing value with text.

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

 

Highlighted
Contributor III
Contributor III

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