Discussion Board for collaboration related to QlikView App Development.
I have got large amount of data which looks something like this
Kpi Location numerator Denominator
1 London 3 5
1 Essex 4 8
1 Sussex 5 2
1 Newcastle 7 4
1 Oxford 2 4
I have created a Bar chart with Location on X axis and and percentage on Y axis.
Percentage is calculated by (Numerator/denominator)*100
I am looking to calculate the AVERAGE and display it in a text box under the chart wrt to KPI 1.
Can I get some help for this please.
This should do the trick:
For targetting only Kpi=1, use:
View solution in original post
Thanks Johannes Sunden. That was of much help.