I have a line chart, and the default range for the chart is way to high. The measure of the chart is "SUM(ord_totalmiles)" so I thought that using "SUM(ord_totalmiles) * 1.2" would bring it down to acceptable levels. However, the selections that are being made don't seem to be influencing this sum. How do I say in Qlik "Take the max sum (sum of miles) of the dimension (pay period) in question based on the other selections in the chart (the driver the user has chosen), and then multiply that by 1.2".
Here is a picture of the chart showing the problem, I've selected a Driver, yet the range is 300K+ when the max value is only around 1.6K.