Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Aggregated function Sum of Averages

Hi,

trying to sum the average amount for each branch as per below:

Sum(aggr(avg(Balance),Branch))

When selecting one time (ie 09:00) Im getting the correct value.

However, Problem is I cannot plot these values in a graph (hour as dimension), neither can I show these values per hour in a Pivot.

Im missing something here. Any clues?

Sample file attached.

Regards,

Olle


1 Solution

Accepted Solutions
ariel_klien
Valued Contributor

Re: Aggregated function Sum of Averages

Hi,

Try  sum(aggr(avg(Balance),Branch,Time))

BR

Ariel

2 Replies
ariel_klien
Valued Contributor

Re: Aggregated function Sum of Averages

Hi,

Try  sum(aggr(avg(Balance),Branch,Time))

BR

Ariel

Not applicable

Re: Aggregated function Sum of Averages

thanks!

Community Browser