Bubble Chart and RAG rating

infock12 — Mon, 05 Oct 2015 11:09:59 GMT

Hi all,

I am plotting a bubble chart for risk monitoring. Sample data and qvw. attached

I am using Likelihood and Consequence as Dimensions and count (No:) as expression.

I wanted to restrict the bubbles only to 3 colours (Red, Amber, Green). The formula I wanted to write is

=if(count(Consequence) * count (Likelihood) >12, RGB(255,36,0), if(count(Consequence) * count(Likelihood) <=12 and if(count(Consequence) * count(Likelihood) >8, RGB(218, 145, 0)), LightGreen()))

I wrote this under "Colours" tab on the first colour but it did not work. Not sure if I have to add an Aggr function before count? Secondly, where do I enter this formula, i.e., under "Colours" tab or "Expressions > Background colour"?

Finally, I am not able show the value of count (No:) on the bubbles. I tried =count(No:) under Expressions > Show Values but it did not work either. Any help is much appreciated!

Thanks,

Karthik

Re: Bubble Chart and RAG rating

infock12 — Mon, 05 Oct 2015 14:00:40 GMT

Hi all,

This question has not been answered by anyone. Could someone please let me know if you could see this post at all. It doesn't matter if you couldn't give an answer...just wanted to ensure my posts are visible.

Many thanks,

Karthik

topic Bubble Chart and RAG rating in QlikView

Bubble Chart and RAG rating

Re: Bubble Chart and RAG rating