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:
Can anyone think of a nifty formula in a QV chart which I could use to replicate this?
Many thanks for your help!