Min and Max with Count

[michealjohn]

Hi,

I am newbie to Qlikview and facing issue in getting the result. Below is the sample data.

Org_Code, year

AA, 2014
AA, 2015
AA, 2015
AA, 2016
AA, 2017

BB, 2001
BB, 2019
BB, 2018
BB, 2001

CC, 2002
CC, 2003

I need the total count of org_code with max and min org_code.
For example, total count of AA is 5, BB is 4, CC is 2
The result I want is;

Expected Result:
Max Org_Code --> AA - 5
Min Org_code --> CC - 2

Ppease help on how to have the dimension and expression for it in qlikview

[Taoufiq_Zarra · Accepted solution]

Hi,

Welcome to Qlik!
attached a qlikview file with the formulas or here they are

='Max Org_Code --> '&FirstSortedValue(Org_Code,-(Aggr(Count(year),Org_Code)))&'-'&Max(Aggr(Count(year),Org_Code))

='Max Org_Code --> '&FirstSortedValue(Org_Code,(Aggr(Count(year),Org_Code)))&'-'&Min(Aggr(Count(year),Org_Code))

[Taoufiq_Zarra]

thanks @sunny_talwar 

[sunny_talwar]

🙂

[michealjohn]

thanks a lot for your help. Let me check on it and confirm you as I am having some issue in loading this .qvw file.

[michealjohn]

working fine as expected..thanks a lot for your help. Let me try to run with my data lake.. 🙂

[Taoufiq_Zarra]

Awesome, can you accept in this case the right solution 😁