topic Help with sumproduct equivalent for scatter in QlikView https://community.qlik.com/t5/QlikView/Help-with-sumproduct-equivalent-for-scatter/m-p/969658#M948088 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm looking to replicate an excel scatter chart in Qlik which uses the SUMPRODUCT function to plot individual point plots for each axis:</P><P></P><P>=SUMPRODUCT(--(A2:$A$16=A2))</P><P>=SUMPRODUCT(--(A3:$A$16=A3))</P><P>... and so on..</P><P></P><P>This gives a scatter like this:</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109668_Capture.JPG" style="height: 406px; width: 620px;" /></P><P></P><P>Can anyone think of a nifty formula in a QV chart which I could use to replicate this?</P><P></P><P>Many thanks for your help!</P></BODY></HTML> Tue, 22 Dec 2015 09:40:07 GMT 2015-12-22T09:40:07Z Help with sumproduct equivalent for scatter https://community.qlik.com/t5/QlikView/Help-with-sumproduct-equivalent-for-scatter/m-p/969658#M948088 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm looking to replicate an excel scatter chart in Qlik which uses the SUMPRODUCT function to plot individual point plots for each axis:</P><P></P><P>=SUMPRODUCT(--(A2:$A$16=A2))</P><P>=SUMPRODUCT(--(A3:$A$16=A3))</P><P>... and so on..</P><P></P><P>This gives a scatter like this:</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109668_Capture.JPG" style="height: 406px; width: 620px;" /></P><P></P><P>Can anyone think of a nifty formula in a QV chart which I could use to replicate this?</P><P></P><P>Many thanks for your help!</P></BODY></HTML> Tue, 22 Dec 2015 09:40:07 GMT https://community.qlik.com/t5/QlikView/Help-with-sumproduct-equivalent-for-scatter/m-p/969658#M948088 2015-12-22T09:40:07Z