Discussion board where members can get started with QlikView.
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
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.
Both left and right figures highlighted in yellow are the same and I assume the red fields should be GREEN but it’s not..
Here you have an screenshot where you need to add your formula:
Is it possible for you to attach the qvw file? Because it should work.
This is what I get, Maybe my expression is incorrect.
You are comparing value with text.
Change the 'Actual Trust Spend' to the name of the calculated field [Actual Trust Spend].