Creating a Bell Curve
In this video, learn how to create a bell curve in Qlik Sense and Qlik Cloud to analyze the distribution of your data. We’ll guide you through the process of setting up a combo chart and using Qlik functions to overlay a bell curve on your data visualization.
First, we’ll start by adding a combo chart to your sheet. You’ll learn how to add a dimension by creating a calculated dimension using the round function, specifically for temperature in this example. After that, we’ll show you how to add a measure using the count function to visualize the frequency of the dimension values.
Next, we’ll introduce how to overlay a bell curve on your chart by using the normal distribution function (norm.dist) and the standard deviation function (stdev). We’ll explain how these functions work together to create the bell curve, showing the distribution of your data.
We’ll also cover how to label the bell curve and the bars in your chart to ensure that the legend reflects the appropriate labels. Additionally, you’ll learn how to use markers to display the bell curve as data points, making it easier to assess if your measurements are normally distributed or if there are any anomalies.
By the end of this video, you’ll have a clear understanding of how to create and customize a bell curve in Qlik Sense to better analyze your data distribution.