topic Visual Cues in QlikView

Visual Cues

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

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.

Re: Visual Cues

sunny_talwar — Fri, 19 Aug 2016 08:25:44 GMT

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

Re: Visual Cues

k_burata — Tue, 23 Aug 2016 02:44:02 GMT

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.

Re: Visual Cues

sunny_talwar — Tue, 23 Aug 2016 08:13:22 GMT

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())

Re: Visual Cues

k_burata — Fri, 26 Aug 2016 05:27:15 GMT

Hi Sunny,

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

Do I need to add more modifiers?

Cheers,

Re: Visual Cues

sunny_talwar — Fri, 26 Aug 2016 08:28:38 GMT

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