Calculate average age based on Visits

Krish — Sat, 16 Nov 2024 02:25:17 GMT

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.

Re: Calculate average age based on Visits

Brett_Bleess — Tue, 01 Oct 2019 21:49:02 GMT

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

topic Re: Calculate average age based on Visits in QlikView

Calculate average age based on Visits

Re: Calculate average age based on Visits