QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Not applicable

Calculatuing Average

Hi,

I have got large amount of data which looks something like this

example:

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.

1 Solution

Accepted Solutions
Master

This should do the trick:

=avg(numerator/denominator)*100

For targetting only Kpi=1, use:

=avg({\$<Kpi={1}>} numerator/denominator)*100

2 Replies
Master

This should do the trick:

=avg(numerator/denominator)*100

For targetting only Kpi=1, use:

=avg({\$<Kpi={1}>} numerator/denominator)*100

Not applicable
Author

Thanks Johannes Sunden. That was of much help.

Regards,

K.V