Max of sales help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In the below Pivot Table I have to show only Department wise Max sales employee details only instead of all the  other employees.

Current Table:

Expected Table:

I have used the below expression for Sales. please help me to modify the below expression for max of sales

Sum(${<MonthDiff={0}>}Sales)

Thanks in advance

[Channa]

max(Aggr(SUM(salary),department,employee))

[jonathandienst]

Use Department as dimension, and the expressions:

=FirstSortedValue(Employee, -Sales)
=Max(Sales)

For max employee and sales value.

[mahitham]

Hi @Channa 

I have tried your solution but its not working.

[mahitham]

Hi @jonathandienst 

I have tried your solution but its not working.

[mahitham]

Hi @Channa 

For Measure I have used this expression Sum(${<MonthDiff={0}>}Sales). Here MonthDiff={0} is mandatory to see the current month values. same like below created a Pivot Table in Qlik.

Here requirement is Department wise Highest Sales employee name and his sale amount only need to show.

Please help me on this.

[Channa]

in this case you need to add condition instead of sales add your expression in place of sames

try both

=FirstSortedValue(Employee, -Sales)
=Max(Sales)

[mahitham]

Hi @Channa 

By adding set analysis expression in Firstsortedvalue getting error in expression.

[Channa]

take the qvf

send me ur set expression i will try to update

[mahitham]

hi @Channa 

Thanks for your help.

Actually I was not explained the requirement clearly.In my app why firstsortedvalue is not working I have found.

Actually here I have considered dummy data for explaining requirement.

Could you please check the below thread. Actually I have the ID Field based on that I have to consider the max of month count. In  department wise which employee count is high(based on id field) his name and count need to show in Table.

Could you please help me the below thread. 

https://community.qlik.com/t5/New-to-QlikView/Max-of-trades-help/m-p/1553454#M371273