Colormix Wizard

[#1]

Hi everyone.

I am experiencing some issues with the Colormix function. I have tried using both a Pivot as well as a Straight table but to no avail.
I have two dimensions but for the purposes of my trial and error process, I even reduced it to just one dimension.

Basically, this is my expression:

(fabs(sum({<Version = {'Actual'}>} Amount_YTD * [INVERT SIGN] * SIGN))

/

sum({<[Actual Budget] = {'Actual'}, [LOS/Pay Status] = {'Paying'}>} [Value]))

In the Colormix wizard, when prompted to enter the expression to base the colours on, I re-pasted this expression.

On the next screen, if I select Auto Normalize and only enter an Intermediate value (0.75), then I get no colours.

If I uncheck Auto Normalize and attempt inputting my own Upper Limit of 1, Intermediate of 0.75 and Minimum Limit of 0.5, I get only greens even though my data had a host of value ranges.

I then played around a bit and used my expression as well in the ranges, for example:
Upper Limit: fabs(max({<Version = {'Actual'}>} Amount_YTD * [INVERT SIGN] * SIGN))
Intermediate Limit: (fabs(avg({<Version = {'Actual'}>} Amount_YTD * [INVERT SIGN] * SIGN)) / avg({<[Actual Budget] = {'Actual'}, [LOS/Pay Status] = {'Paying'}>} [Value]))
Minimum Limit: (fabs(min({<Version = {'Actual'}>} Amount_YTD * [INVERT SIGN] * SIGN)) / min({<[Actual Budget] = {'Actual'}, [LOS/Pay Status] = {'Paying'}>} [Value]))

Basically, even when I do get some colurs coming through, they would never be greens, yellows and reds. It would always start from yellow, even though I have values lower than the minimum for yellow.

I am aware that the colormix wizard did say that the function looks at the overall min, max and middle values and perhaps this is why it is messing up the colours when filtering on one particular dimension value by showing colours of a non-sensible range (eg. all yellows or reds). I have been through several online articles and though I learnt alot about using Colormix with bubble charts etc, I'm afraid none of them apply to what I am trying to mimic as per my screen shot.

Would greatly appreciate your assistance.

Many thanks.

[Clever_Anjos]

Is it possible to post a sample of you app?

Colormix really depends on data

[#3]

Hi!

Please accept my sincere apologies for the delayed response. I have been unable to login to QlikView on my side. Had to get my profile reset.

Nonetheless, the data in the model is highly sensitive. I tried to scramble it a bit but was advised by the client to hold on for the moment. I am still eager to know how to rectify the issue so will see at a later stage if I can come up with something we can work with.

Many thanks.