Defining axis range using expressions

In this video, you'll learn how to use Qlik's expressions to define ranges in visualizations, making your data displays more dynamic. We'll show how to create a gauge chart using the sum of sales as its measure and set minimum and maximum values with expressions. You'll see how to set the maximum value using the sum of the sales target, define limits like the median and average, and apply colors to distinguish ranges. We'll also demonstrate setting ranges in bar and line charts using expressions like standard deviation and average sales target. Sum of sales target: Sets the maximum value in a gauge chart. Median of the sales target: Defines a limit in a gauge chart. Average of the sales target: Defines a second limit in a gauge chart. Standard deviation of the sales: Sets the minimum value in a bar chart. Average of the sales target: Also used to set the minimum value in a line chart.