Max function to find results in a different dimension

EGilbert — Sat, 16 Nov 2024 00:12:40 GMT

I am trying to use the max result from a field to produce a value from another field. For example in the simple chart below

I would like have a listbox for month and 2 text boxes for results

first text box would produce max count of sales in the selected month by a company (if month J is selected the result would be 3 because company A has a total of 3 entries in month J)

second text box would produce the company name that has the most entries in a given month(if month J is selected the result would be "A" as the company has 3 entries which is the most for any company in month J).

I have tried aggr and concat but cannot get them to work the way i would like.

Re: Max function to find results in a different dimension

Kushal_Chawda — Fri, 31 Jul 2020 22:12:14 GMT

//For value =max(aggr(Count(Sales),Company)) //For company =FirstSortedValue(distinct Company, -aggr(Count(Sales),Company))

topic Max function to find results in a different dimension in QlikView

Max function to find results in a different dimension

Re: Max function to find results in a different dimension