Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to get the max of dimension?

Hi,

I am using a straight table, in which I wanted to show the highest repeated category from my Item table. Data looks as follows,

Capture.JPG

From the above table, I need a straight table as follows,

Cature.JPG

Please help me to figure it out !!

Thanks,

Mohan

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Hi

Try this expression

FirstSortedValue(Category, -aggr(max(aggr(Count(PCODE),CustomerID,Category)),CustomerID,Category))

View solution in original post

3 Replies
Highlighted
Creator II
Creator II

Hi

Try this expression

FirstSortedValue(Category, -aggr(max(aggr(Count(PCODE),CustomerID,Category)),CustomerID,Category))

View solution in original post

Highlighted
Creator II
Creator II

Hi Mohan,

Did it work ?

Highlighted
Partner
Partner

Hi Scotly,

Yeah !! It works Thanks for your head up..!!