Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qliklizzy
Contributor

Colormix heatmap straight table stuck on expression

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

 

 

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Colormix heatmap straight table stuck on expression

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 ?

Highlighted
qliklizzy
Contributor

Re: Colormix heatmap straight table stuck on expression

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
Esteemed Contributor

Re: Colormix heatmap straight table stuck on expression

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
Contributor

Re: Colormix heatmap straight table stuck on expression

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
Esteemed Contributor

Re: Colormix heatmap straight table stuck on expression

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

qliklizzy
Contributor

Re: Colormix heatmap straight table stuck on expression

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