Calculate average age based on Visits

[Krish]

Hi,

I have a requirement to display the Average Age column, Model and  Make that corresponds to the  Top 5 models visited in a particular time.

The result should be like below.  The order is determined by calculating the number of visits of each model.

Count(visits) --    =Max(Aggr(count(Visits),[Model Name] ,[Vehicle Make]))

Make	Model	Age
Toyota	Supra	4
Ford	Mazda	7
Toyota	Highlander	10
Chevy	Blazer	8
Ford	Laser	12

How can this be accomplished.

[Brett_Bleess]

Best I can offer is the following link, you can use it to search just the Design Blog posts, there are hundreds of them, which cover how to do different things, hopefully you can find one that is related to what you wish to do that will help.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett