Qlik Community

Ask a Question

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 
Search instead 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
jsn
Master
Master

This should do the trick:

=avg(numerator/denominator)*100

For targetting only Kpi=1, use:

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

View solution in original post

2 Replies
jsn
Master
Master

This should do the trick:

=avg(numerator/denominator)*100

For targetting only Kpi=1, use:

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

View solution in original post

Not applicable
Author

Thanks Johannes Sunden. That was of much help.

Regards,

K.V