Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I'm new to QlikView and trying to use it to plot equity trading data. I would like to see time on the x-axis and price on the y-axis. I also need different colors depending on whether the data point is for a bid or an ask. The data points have size associated with them, so I would like to plot larger bubbles for larger sizes if possible.
I have a few questions:
Any help would be greatly appreciated!
Thanks!
-Andy
Hi Andy,
You should use a scatter plot for this. I've create a quick example attached. One little trick, to make the bubbles different colours for trades and bids you needs to set this in the expression colour (image attached of where this is the the properties). There is no limit of the number points Qlikview can plot however this will be constrained by the power of you machine (note in a deployment the constraint is the server not the client machine). You may want to consider limiting the time frame plotted or setting up a drill down if that makes sense for your use case.
-Josh