{"id":39357,"date":"2018-11-08T13:33:44","date_gmt":"2018-11-08T08:03:44","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=39357"},"modified":"2018-11-13T18:08:00","modified_gmt":"2018-11-13T12:38:00","slug":"box-plot-in-qlik-sense","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/box-plot-in-qlik-sense\/","title":{"rendered":"Box Plot In Qlik Sense Visualization – Creating a Box plot"},"content":{"rendered":"

1. Objective – Qlik Sense Box Plot<\/span><\/h2>\n

In our last Qlik Sense tutorial, we discussed Qlik Sense text and image visualization<\/a><\/strong>. Today, we will see Box Plot in Qlik Sense Visualizations. Also, we will see the significance of the\u00a0box plot in Qlik Sense and when to use it. Moreover, we will learn how to create a box plot in Qlik Sense along with managing it.<\/span><\/p>\n

So, let’s start Qlik Sense Box Plot Tutorial.<\/p>\n

\"Box<\/a>

Box Plot In Qlik Sense Visualization – Creating a Boxplot<\/p><\/div>\n

2. Box plot in Qlik Sense<\/span><\/h2>\n

We use a box plot to show the distribution of a grouped data set using a whisker\u2019s box plot. Each value point on the box plot will be a whisker\u2019s bar plot.<\/span><\/p>\n

Do you know about Qlik Sense Filter Pane<\/a><\/strong><\/p>\n

\"Box<\/a>

Box Plot in Qlik Sense<\/p><\/div>\n

The whisker\u2019s and box symbol can be broken down into components as marked in the image above.<\/span><\/p>\n

    \n
  1. The <\/span>first whisker<\/span><\/i> marking the lowest\/minimum value of the range or distribution.<\/span><\/li>\n
  2. Box start<\/span><\/i>, which marks the first quartile.<\/span><\/li>\n
  3. Centerline<\/span><\/i>, or median of the data distribution. It is the center of the box and also the second quartile. <\/span><\/li>\n
  4. Box end, <\/span><\/i>marking the third quartile. <\/span><\/li>\n
  5. Last whisker<\/span><\/i>, marking the maximum or highest value of the range. <\/span><\/li>\n<\/ol>\n

    Box plots are the best way to analyze a large amount of data with such small representation symbols as whiskers and boxes. You can set presets for making and analyzing data in a box plots, like for median, for percentile, or for standard deviation. Notice the box plot given in the image below.<\/span><\/p>\n

    \"Box<\/a>

    Qlik Sense Box Plot<\/p><\/div>\n

    It represents the data distribution for temperature recorded yearly in Sweden. The given box plot shows the distribution of average temperatures recorded for distinct years. It can be inferred from the plot that the year 2010 has the most widely ranging distribution of temperatures. Also, the average temperature for each year will be the value corresponding to the central line of each plot. The blue dots are the outlier values which do not fall within the distribution range of whisker\u2019s plot.<\/span><\/p>\n

    Do you know about Qlik Sense Treemap Visualization<\/a><\/strong><\/p>\n

    3. Creating a Box Plot Chart<\/span><\/h2>\n

    Follow the steps given below to learn how to create a box plot in Qlik Sense. <\/span><\/p>\n

    Step 1:<\/b> Select the option Box plot from the assets panel of the sheet that you are editing. Drag and drop the box plot onto the editing grid. You will see an incomplete box plot created on the grid. <\/span><\/p>\n

    \"Box<\/a>

    Box plot Chart in Assets Panel<\/p><\/div>\n

    Step 2:<\/b> Now it is time to add dimensions and measure for the plot. You can add up to two dimensions and one measure in a box plot. The order in which you add a measure matters a lot. The first dimension that you add defines the box. The second dimension defines the Y-axis whereas, the measure defines the values and ranges of the X-axis. After adding dimensions and measure, you can use more settings options to customize the box plot as you like from the properties panel which we will discuss in detail in the next section. The default preset for a box pot is set on Standard(Tukey). You can change it from the Preset option if you want to.<\/span><\/p>\n

    Let’s learn more about Qlik Sense Color Functions<\/a><\/strong><\/p>\n

    Step 3: <\/b>Once you have created the box plot as per your liking, click on <\/span>Done<\/b> to exit the editor and go to the sheet view. The final box plot displays on the sheet. <\/span><\/p>\n

    \"Box<\/a>

    Sheet View – Final Box Plot<\/p><\/div>\n

    In the box plot shown above, the distribution of values is for total products sold in each country. The first dimension we used in this box plot was Product type, then Y-axis dimension was \u2018Country\u2019, and for X-axis it was \u2018Sum(Product Quantity)\u2019labeled as \u2018Total sold products\u2019. A standard box plot for each country is represented which shown the maximum and minimum values, third and first quartile and the median value. You might have noticed, the box plot for Australia is not properly created because there were too few values for them to make a wide distribution range. <\/span><\/p>\n

    4. Properties Panel in Box Plot in Qlik Sense\u00a0<\/span><\/h2>\n

    All the settings and customization of the box plot is done using the properties panel. <\/span><\/p>\n

    a. Data<\/span><\/h3>\n

    From the Data section, we can manage all the dimensions and measures. You can add the box and Y-axis dimension, add an expression or label to them. Next, you can also add an X-axis measure field. No aggregation is added by default. If you want to add an aggregation function, then you will have to do it from this section.<\/span><\/p>\n

    Do you know about Qlik Sense Conditional Functions<\/a><\/strong><\/p>\n

    \"Box<\/a>

    Data in Qlik Sense Box Plot<\/p><\/div>\n

    b. Box Plot elements<\/span><\/h3>\n

    From the box plot elements section, you get to set the preset type from the three options of Standard (Tukey), Percentile based, and Standard deviation. <\/span><\/p>\n

    \"box<\/a>

    Box Plot Elements<\/p><\/div>\n