Seems pretty straightforward to me:
Dim1: Day x-val
Dim2: Amount y-val
Expression: count(Amount y-val)
I correct myself, it is not as straightforward to implement in QlikSense as I thought - apologies for this. I managed to create something very close to it using an aggregated dimension utilizing the aggr() function.
ScatterPlot.qvf 176.0 K
The scatter plot in QlikSense needs atleast 2 measures and the 3rd measure shows the size of the bubble. As there are only 3 fields in totally this cannot be achieved using the implicit scatter plot. Instead you can achieve this using an extension as Bruno mentioned.
Make use of this expression to calculate the frequency.
Thanks and Regards,
Ok. We're getting there.
Grid Extension visually represents the data, but doesn't seem to scroll like the scatter plot. The "day(x-vals)" values can get up into the 1000s so I need to be able scroll horizontally. The amount values (y-vals) scale needs to be dynamic to account for various ranges of amount. Our current Excel visualizations sort the data by "day" and connect each point adjacent point in the scatterplot with a line. It looks like the following:
The yellow is an overlay that we will eventually want to implement. The green dots are what I need to render in Qlik Sense. I need the scale on the left and bottom to be consistent.
We will eventually want to be able to put three sets of data on the same graph, turning them on or off. The excel version is very slow and static. We want an interactive dynamic capability for analysts.
There are three other visualizations that need to be rendered as well.