Discussion Board for collaboration on QlikView Layout & Visualizations.
I have the following set of numbers AAA and BBB. BBB needs to be divided by AAA and produce a 'capped' result between 0-1, and then calculate an average of these capped values in a gauge chart.
In a straight table the capped average is trivial to accomplish, using the 'Total mode' functionality and selecting 'Average of Rows'. But how can I get the capped average in a gauge chart?
the expression is the same, the only thing you have to do is to enter a dimension for the Total like:
Sum(AAA)/SUM(Total <Dimension1,Dimension2,...> BBB)