Aggregation average for a measure master item

[Mini_Elaine]

Hi All,

I have a measure master item called as 'on target' based on 4 different dimensions for my product. This 'on target' field is % with missing data. I would like first to display the products with 'on target' calculated and a KPI for average % of 'on target' field.

It works perfectly on table chart to calculate average however it doesnt work with KPI. I used Avg(Aggr([On target], [Product])) to calculate KPI and on table chart I used Qliksense average to display. Any clue why it returns two different values? How can I make it average to show 83% as table shows rather 7% from KPI chart?

Many thanks,

Min

[anat]

Avg(Aggr(Avg([On target]), [Product])) 

[Mini_Elaine]

Thanks Annat. It didnt work as Qliksense couldn't find my [On target] field as a measure in purple colour?

[Chanty4u]

• Try this
• Avg(TOTAL <[Product]> [On target])

[Aasir]

Avg([On target])
This should work, a view of measures on each table side panel is required to tell with additional context.