Colormix heatmap straight table stuck on expression

[qliklizzy]

Hello

I have a straight table showing; by date a count of patients waiting over 18 weeks

with this expression:   count(if(WaitWeeks>17, Denominator))  

I would like to heatmap the results, I've looked into colormix wizard as I think this should do it but I just cannot get it to work...

I assume the expression needed in the wizard is the same as the expression I have but it doesn't like it - should it be an average of that expression that needed?

Thanks for your help if possible

Liz x

[YoussefBelloum]

Hi,

I think it all depend on the definition of your WaitWeeks column.. for example, a value 5 on this column, respresents 5 weeks of waiting or it is just the Week 5 ?

[qliklizzy]

it shows that a patient is waiting 5 weeks

then in my table I am counting all the patients who wait over 17 weeks ?

thanks

[YoussefBelloum]

EDITED

ok, why do you need colormix here ?

you just want to flag the patients who waited more than 18 weeks, right ?

try the Rgb() function, using an if on the WaitWeeks column

[qliklizzy]

Hi

no I have these flagged in font red  as a count over 18 weeks as they are breaches (waited too long in terms of a target)

however the count is displayed by date for each week - I am just showing whether or not our breaches are increasing or decreasing to visually show the results quicker but also the counts.

thanks

[YoussefBelloum]

I suggest you to send the expected output on the existing table using an image for example

[qliklizzy]

thanks

here is my table attached,

I want to apply a heat map to breach 18 if only 8 weeks of data is selected then the heatmap should just be applied to what is shown I.e. Red for higher numbers and green for lower over the cohort.  users can select 12 or any number of weeks data

the breach 18 field is the expression : count(if(WaitWeeks>17, Denominator))