I have a gauge chart in Qlikview in which I am trying to show the current actual value versus the year end target value. I cannot seem to get the Segments right. I just have two simple expressions, one for actual and one for target. How do I set up the segments to do this? I'm not sure what the Min and Max should be or the lower bounds.
Hi, Generally you set up the measure as your actual value (e.g. sum(Actual Value)), and in the Range Limits under Appearance, set up the max as your target value (e.g. Avg(Target Value)). I use Qlik Sense, but it should be very similar in qlik view as well.
Below is the sample, I use 10 as actual value and 15 as target value.