Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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..!!