Not applicable
2015-12-22
04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Can anyone think of a nifty formula in a QV chart which I could use to replicate this?
Many thanks for your help!
326 Views
0 Replies