Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with sumproduct equivalent for scatter

Hello all,

I'm looking to replicate an excel scatter chart in Qlik which uses the SUMPRODUCT function to plot individual point plots for each axis:

=SUMPRODUCT(--(A2:$A$16=A2))

=SUMPRODUCT(--(A3:$A$16=A3))

... and so on..

This gives a scatter like this:

Capture.JPG

Can anyone think of a nifty formula in a QV chart which I could use to replicate this?

Many thanks for your help!

0 Replies