The following recipe showcases an interesting concept in the use of scatter charts in Qlik Sense. This feature is available from version 2.0+ of Qlik Sense.
Load the following code into your Qlik Sense application:
Transactions: Load Round(1000*Rand()*Rand()*Rand()) as Sales, Round(10*Rand()*Rand()*Rand()) as Quantity, RecNo() as TransID Autogenerate 1000000 While rand()<0.5 or IterNo()=1;
- Create a new sheet and drag a scatter plot chart object onto the content page.
- Add TransID as a dimension.
- Add Sum(Sales) as the first measure. Label it
Sales. - Add Sum(Quantity) as the second measure. Label it
Quantity. - Click on Done.
- Title the chart as
Sales vs Quantity. - You will notice that you cannot select data inside the chart like you can with every other Sense visualization. To navigate the data you have to scroll in and out using the mouse wheel. The object will look like the following image; try scrolling in:
- As you zoom further into the chart , the number of data points being displayed reduces at once. You will eventually see the details of each data point displayed in each block. The higher density blocks are also color coded as show in the following:
- Eventually, you can zoom in enough and reduce the number of data points to where they are identifiable individually. At this point the graphic will revert its display to a more standard scatter chart look. Those with enough space around them actually have the value displayed as shown in the following:
This is a very intelligent addition by Qlik to the normal scatter chart display. This chart plots over a million data points effortlessly. Doing this the traditional way is very process intensive. When you want to extract data volumes of this size, you normally tend to look at the pattern and not at the individual numbers. This archives both by displaying the individual points at the point they would make sense and not before.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.