Bubble chart in QlikView is an extension to the scatter chart. Compared with scatter charts, bubble charts contain an additional dimension to represent the size. Bubble charts are helpful in detecting outliers and correlations that are uncovered. Through this article, you will get detailed knowledge about building bubble charts.
If you would like to become an Qlik Sense Certified professional, then visit Mindmajix - A Global online training platform: " Qlik Sense Certification Training Course ". This course will help you to achieve excellence in this domain.
The Bubble chart in the QlikView will deliver within the browser using VML or else SVG. It also displays certain tips when the position of the bubble is moved. It is mostly used to visualize the given data sets in two or else four dimensions. The visualization of the first two dimensions is as coordinates and the third one is for color and the fourth as size.
Everyone has basic knowledge of custom tables in the QlikView technology before. It mainly allows the users to build the reports and also helps to select the required combination of dimensions and measures of pre-defined lists. It also helps to perform a job like multiple tables and also encourages user-driven analysis. It is also a sort of precursor to Qlik Sense.
[ Related Article:- QlikView IntervalMatch Function ]
In a simple manner, the bubble chart is considered as the variation of scattering with an additional measure that can be shown or represented by size. It is probably used to spot correlations and outliers which might have probably missed. When creating a custom bubble chart, one must face a challenge which is compared to the table that shows certain conditions. The specific inputs are given as X-axis, y-axis, and bubble size. There are certain measures that are possible with certain conditions that may not give a guarantee on the correct order. When there is a requirement of only one dimension then it is more easy and elegant to calculate or else maintain single dimensions.
First, you have to create a table with all the required measurements and dimensions. It is better to perform it in the spreadsheet which can be easily used and updated in the further requirements.
In the below screenshot, you can see a table in the spreadsheet.
In the below screenshot, you can see the selection of the x-axis and z-axis.
In the below screenshot, you can see the bubble chart built using the corresponding table.
This scatters chart or else Bubble chart is quite easy to make in QlikView Technology. There are a few things where you may probably get confused. The basic thing to get confused is the Dimension where you may think whether it is identical to one ax of the chart. Sometimes, the logical dimensions are not the same as the graphical one as well.
Generally, each bubble represents the country which could be one bubble for customer, product or else supplier. There will be some dimensions and also measures that will play a vital role in the chart.
In some of the graphs, the X-Coordinate is for the per Capita GDP and the y-coordinate is for life expectancy. One can also probably use certain gross margins, total order values, net cost or else some other numbers. All these are generally used for the axes in the graph. There is a requirement of two expressions wherein the other purpose, you can also have use of the third expression. The third expression will be for the size of the bubble. When it probably comes to the measures, the next confusing thing is that the country has its own one GDP but this QlikView wants an aggregation function such as sum() or else Avg(). The main cause or else reason is that QlikView will not “know” the data in the several records which is exactly for each dimensional value. To tell the exact value, there will be a usage of aggregation function to tell that QlikView to perform that it must contain more than one record. For sure there should be a one record per dimensional value which is not a matter of using sum() and avg().
You can generally perform it in an exact manner once the dimensions or else expressions are known clearly.-
[ Related Page:- Data modeling in QlikView ]
After completion of the above process, Now you have made a bubble chart. To make more beautiful with certain styles then you must follow given below
The color code of the bubble will be as per the performance that can also communicate with a target line.
By using this chart in the QlikView, it is a high efficiency that helps to take up the next advanced level. Here are the main reasons to use are
A bubble chart is useful for analyzing and displaying the data. We can study the relations between the given data.I hope this article helps you in getting the required information.
If you have any queries, let us know by commenting in the below section.
Vinod Kasipuri writes about various IT platforms such as QlikView, Qlik Sense, and Perl Scripting, at Mindmajix. He loves to explain the concepts he writes in simple terms. He is also engaged in researching trends in AngularJS and LabView. Reach out to him via LinkedIn and Twitter.