# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Help with Aggr Function

Hi everyone,

I create Bar Char with dimensions: Region

The measure should be: avg of (Max(to_date)-max(start_date) group by to_category,from_category)

I try the following expression:

Avg(aggr(Max(to_date)-max(start_date)),to_category,from_category))

- But I didn't got any result.

This is strange because when I create a table with the dimensions: Region, from_category, to_category

and the measure : Max(to_date)-max(start_date) with type total - avg.

- I have got a results.

Thank you!

7 Replies
MVP

## Re: Help with Aggr Function

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category))

Contributor

## Re: Help with Aggr Function

I forgot to mention - I have more alternative dimensions..

MVP

## Re: Help with Aggr Function

Would you be able to share a sample?

Honored Contributor III

## Re: Help with Aggr Function

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category,alternative dim1,alternative dim2..))

Contributor

## Re: Help with Aggr Function

It's bring different results when you grouped by more dimensions.

For example :

I want that when the user Choose dimension Region the calculate wil be:

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category)

when the user Choose dimension Geography the calculate wil be:

Avg(Aggr(Max(to_date) - Max(start_date), Gegraphy, to_category, from_category)

MVP

## Re: Help with Aggr Function

how are they choosing dimensions? is it from a list of island table entries?

Contributor

## Re: Help with Aggr Function

I just defined the dimensions as alternative and the following list is appear - The user should pick from the following list: