Calculate average age based on Visits

Krish · ‎2019-09-23

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 · ‎2019-10-01

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

General Question