Visual Cues

[k_burata]

Hi,

Would like to be able to correct the visual cues from the "Current" to the "Desired" output. Below is the image:

I would want to be able to mark cells on the Actual Rows red if it's over the budget and green if not. Right now it's only doing it for the total and not for the individual columns.

I have this currently:

Expression:

=sum([Position Property Value])

Visual cues expression:

Upper >= =sum({<EPPType = {"BUDGET"}>}[Position Property Value]) + 1 --> Red

Thanks.

[sunny_talwar]

Why don't you try Background Color expression to get this done?

[k_burata]

Hi Sunny,

I tried doing what you advised but still wasn't able to get the desired result. From the image below it should only be

Red if ACTUAL is greater than BUDGET.

Here's he expression that I used. Just wondering where I missed since I am still learning QlikView.

if([EPPType] = 'ACTUAL' and (Sum({$<[EPPType]={'ACTUAL'}>} [Position Property Value]) >= Sum({$<[EPPType]={'BUDGET'}>} [Position Property Value])), Red())

Cheers.

[sunny_talwar · Accepted solution]

But in your condition you have used greater than and equal to sign (>=)? Change that to just greater than (>)

If([EPPType] = 'ACTUAL' and (Sum({$<[EPPType]={'ACTUAL'}>} [Position Property Value]) > Sum({$<[EPPType]={'BUDGET'}>} [Position Property Value])), Red())

[k_burata]

Hi Sunny,

Removed the "=" but still didn't work.

Do I need to add more modifiers?

Cheers,

[sunny_talwar]

Difficult to say, would you be able to share a sample?