Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan_1105
Partner - Creator III
Partner - Creator III

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
scotly-victor
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
scotly-victor
Creator II
Creator II

Hi

Try this expression

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

scotly-victor
Creator II
Creator II

Hi Mohan,

Did it work ?

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Hi Scotly,

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