topic Multiplication in bubble chart in QlikView https://community.qlik.com/t5/QlikView/Multiplication-in-bubble-chart/m-p/970536#M967726 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am creating a bubble chart for risk monitoring. The table has 4 columns. Sample data attached</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 268px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="29"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">No:</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="95"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Consequence </STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Likelihood</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Total</STRONG></TD></TR></TBODY></TABLE><P></P><P>I am using Likelihood and Consequence as Dimensions and count (No:) as expression.</P><P></P><P>I wanted to restrict the bubbles only to 3 colours (Red, Amber, Green). The formula I wanted to write is</P><P>=<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN> (<SPAN style="color: #800000;">Likelihood</SPAN>) &gt;12, <SPAN style="color: #0000ff;">RGB</SPAN>(255,36,0), <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Likelihood</SPAN>) &lt;=12 <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Likelihood</SPAN>) &gt;8, <SPAN style="color: #0000ff;">RGB</SPAN>(218, 145, 0)), <SPAN style="color: #0000ff;">LightGreen</SPAN>()))</P><P></P><P>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 &gt; Background colour"?</P><P></P><P>Finally, I am not able show the value of count (No:) on the bubbles. "Labels on Data Points" under "Presentation" tab is ticked but under Expression tab is deactive. How would I&nbsp; bring the data points. Any help is much appreciated!</P><P></P><P>Regards,</P><P>K</P></BODY></HTML> Wed, 30 Sep 2015 14:08:12 GMT infock12 2015-09-30T14:08:12Z Multiplication in bubble chart https://community.qlik.com/t5/QlikView/Multiplication-in-bubble-chart/m-p/970536#M967726 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am creating a bubble chart for risk monitoring. The table has 4 columns. Sample data attached</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 268px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="29"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">No:</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="95"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Consequence </STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Likelihood</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="72"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Total</STRONG></TD></TR></TBODY></TABLE><P></P><P>I am using Likelihood and Consequence as Dimensions and count (No:) as expression.</P><P></P><P>I wanted to restrict the bubbles only to 3 colours (Red, Amber, Green). The formula I wanted to write is</P><P>=<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN> (<SPAN style="color: #800000;">Likelihood</SPAN>) &gt;12, <SPAN style="color: #0000ff;">RGB</SPAN>(255,36,0), <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Likelihood</SPAN>) &lt;=12 <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Consequence</SPAN>) * <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Likelihood</SPAN>) &gt;8, <SPAN style="color: #0000ff;">RGB</SPAN>(218, 145, 0)), <SPAN style="color: #0000ff;">LightGreen</SPAN>()))</P><P></P><P>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 &gt; Background colour"?</P><P></P><P>Finally, I am not able show the value of count (No:) on the bubbles. "Labels on Data Points" under "Presentation" tab is ticked but under Expression tab is deactive. How would I&nbsp; bring the data points. Any help is much appreciated!</P><P></P><P>Regards,</P><P>K</P></BODY></HTML> Wed, 30 Sep 2015 14:08:12 GMT https://community.qlik.com/t5/QlikView/Multiplication-in-bubble-chart/m-p/970536#M967726 infock12 2015-09-30T14:08:12Z