topic Re: Scatter Chart in QlikView https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044308#M926757 <HTML><HEAD></HEAD><BODY><P>May be like attached?</P></BODY></HTML> Mon, 04 Apr 2016 02:51:05 GMT settu_periasamy 2016-04-04T02:51:05Z Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044306#M926755 <HTML><HEAD></HEAD><BODY><P>I have 3 regions and related data in the attached QVW.In 1 exp I have Cost/Rsf and in other I have Cost/Csf...but since one of the expressions on NOAM and LATAM has 0 I only see ASIA.Where as I want to show 0 as well. </P><P></P><P>Ex: I want NOAM TO<SPAN style="font-size: 10pt; line-height: 1.5em;"> show Cost/Csf : 0 and Cost/HC = $40 ?</SPAN></P><P></P><P></P><P>How can I do that ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044306#M926755 2020-11-25T16:16:04Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044307#M926756 <HTML><HEAD></HEAD><BODY><P>How about for your two expressions:</P><P></P><P><STRONG>Cost/RSF</STRONG></P><P>=If (CSF=0, 0,SUM(Cost)/SUM(CSF))</P><P></P><P><STRONG>Cost/FTE</STRONG></P><P>=If (HC =0, 0,sum(Cost)/sum(HC))</P><P></P><P><IMG alt="1.png" class="jive-image image-1" height="178" src="https://community.qlik.com/legacyfs/online/120348_1.png" style="height: 178.226px; width: 325px;" width="325" /></P><P>Regards,</P><P>Carlos</P></BODY></HTML> Mon, 04 Apr 2016 02:35:30 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044307#M926756 clondono 2016-04-04T02:35:30Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044308#M926757 <HTML><HEAD></HEAD><BODY><P>May be like attached?</P></BODY></HTML> Mon, 04 Apr 2016 02:51:05 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044308#M926757 settu_periasamy 2016-04-04T02:51:05Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044309#M926758 <HTML><HEAD></HEAD><BODY><P>Ya...Thank you but what did you dIfferently... ?</P></BODY></HTML> Mon, 04 Apr 2016 03:04:26 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044309#M926758 2016-04-04T03:04:26Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044310#M926759 <HTML><HEAD></HEAD><BODY><P>I didn't do anything differently. When the value divided by 0, it gives Null value or Missing value (Means '-' hyphen)</P><P>so, just i used rangesum(field1/Field2) -&gt; this gives 0 instead of Null.</P><P>Let's know, is this your need or something else?</P></BODY></HTML> Mon, 04 Apr 2016 03:09:49 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/1044310#M926759 settu_periasamy 2016-04-04T03:09:49Z