Can you explain Boxplot and Histogram in QlikSense?

Boxplot

The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the distribution of the values, focusing them generally into quartiles where 25% of the values, for example, fall into an area of the chart. The boxplot comes with automatic options for Standard (Tukey), Percentage, or Standard Deviation plots. The whisker length can also be configured with the default being 1.5 quartiles from either side of the box.

Histogram

The histogram is a way to group the frequency of a numeric dimension into a range. For example, how many values were between 1 and 5, and how many were between 6 and 10. It is a great way to visualize numbers that fall into a normal distribution. My data did not fall into a normal distribution.

The requirement for this chart is simply a single dimension.  It must be numeric which means that when you go to add a dimension, you will only find fields in the list that are numeric. In this case, I went ahead and created a field in the script that did the row-level math to determine the cases per 100,000 before using it in my chart. It will count up the rows into bars according to the range that you assign it in Histogram Settings. Because my range went from 0 to 45 thousand, I manually configured the Number of bars to 9.

Share this

kumar1