Blog

QlikView Bubble Chart

  • (4.0)
  •   |   723 Ratings

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 first two dimensions are as coordinates and the third one is for color and fourth as size.

Learn how to use QlikView, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free QlikView Training Demo!

How to build a Bubble chart in QlikView?

Everyone has basic knowledge of custom table 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.

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 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.

 

Follow the below steps to create custom bubble chart

  • 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.

  • After that load them as data islands that makes sure to hide from various fields from the given users. Probably the measurements need to be loaded for three times. You can also repeat for Y and Z as well.

  • You can simply, build your chart by adding calculated dimensions and the three required measures.

  • The last step is to add four list boxes which you require calculating with the given conditions in the chart. This will happen when the selections are missed and the colors to show more information about the dimensions.

Making of Bubble Chart

This scatters chart or else Bubble chart is quite easy to make in QlikView Technology. There are 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 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.

Frequently Asked QlikView Interview Questions & Answers

Where Should be the Bubble Be positioned?

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.

  1. Firstly, create a chart and then use a scatter chart. Then click on the next button
  2. Add the dimensions that you though off and click on the next button
  3. Then add extra fields where you can use two expressions like X and Y controls
  4. If you want the requirement of a bubble chart then you must add the third expression that determines the size of the bubble
  5. Check ‘advance mode’ to the lower left. Then the QlikView 11 probably jumps to the sort page so that you need to click on the back for verification of right aggregation functions for the expressions that are used. The functions can also be changed as per the opinion
  6. Then click on the Finish

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

  • Choose the style as per your wish that is [style-look]
  • Increasing of bubble size [Presentation-Max bubble size]
  • You can event change of one or both axes [Axes]
  • In this, you have to remove the Force 0 options
  • Use a logarithmic scale

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 next advanced level. Here are the main reasons to use are

  • Within the tiny space, the lot of communication can take place
  • The best output is taken which shows the relevance of any ratio against absolute outcomes
  • Probably indication will be given in 2 or else 3 measures that also shows relationship of the data
  • Instantly, you can see outliers
  • It is highly powerful when it comes to information design
Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules