Colormix not working as expected

QFanatic — Sat, 16 Nov 2024 18:35:05 GMT

hi guys

PFA.

In the top chart, I am just doing sum(Volume) for expression. The chart is per REQ_DATE, WKDAY and HOUR.

In the bottom chart, I am calculating the AVG per these dimensions - I have checked the values that I get, and they seem right.

So I am using the calculated Average mentioned, in a Colormix wizard to calculate the background of the cells. This however, doesnt seem right.

Lets use Friday and Saturday Slots for hour 00. The Average for Friday 00 is 1307603. The actual figure for Friday same slot is 2002062 - it shows as green.

Saturday, same slot, average is 1050324, and the actual figure is 1231985, and also shows up as green. Somehow, this doesnt seem right . If this saturday slot is deemed as green, shouldnt the avorementioned Friday be 'more red'?

The colormix statement is a nightmare...

My other option is probably to see if I take my actual 'Totals' field and see what the % difference is between that and the Avg field...if the difference is within %10 (positive or negative), then color the background green, if its not within 10%, make it red.

Any assistance appreciated.

Thanks

Re: Colormix not working as expected

sunny_talwar — Wed, 27 May 2020 11:49:18 GMT

What exactly are you trying to color this based of?

Totals expression or AVG expression?

Re: Colormix not working as expected

QFanatic — Wed, 03 Jun 2020 07:53:58 GMT

Hi Sunny,

I want to compare the total sales to the average.. Per weekday, per time slot.

topic Re: Colormix not working as expected in QlikView

Colormix not working as expected

Re: Colormix not working as expected

Re: Colormix not working as expected