topic Re: Colour not working with calculated field in QlikView

Colour not working with calculated field

solomonadjei — Wed, 25 Nov 2020 16:16:04 GMT

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

Colour

Re: Colour not working with calculated field

jaumecf23 — Mon, 07 Jan 2019 15:42:45 GMT

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.

Re: Colour not working with calculated field

solomonadjei — Mon, 07 Jan 2019 16:01:00 GMT

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

Re: Colour not working with calculated field

solomonadjei — Mon, 07 Jan 2019 16:07:47 GMT

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

Re: Colour not working with calculated field

jaumecf23 — Mon, 07 Jan 2019 16:18:33 GMT

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.

Re: Colour not working with calculated field

solomonadjei — Mon, 07 Jan 2019 16:45:49 GMT

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

Re: Colour not working with calculated field

jduenyas — Mon, 07 Jan 2019 18:59:29 GMT

You are comparing value with text.

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

Re: Colour not working with calculated field

solomonadjei — Tue, 08 Jan 2019 14:05:16 GMT

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