topic Re: Pivot table dimension in QlikView

Pivot table dimension

stephenedberkg — Tue, 06 Oct 2015 08:44:36 GMT

i want to show the top 1st rank salesman(only one salesman) in pivot table dimension

my dimension expression is below

= Only(if( Aggr( rank( (sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Inv'},Month,Year=,Quarter=>}$(vSalesBtn))

sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Credit'},Month,Year=,Quarter=>}$(vSalesBtn)))),SalesMan)=1,SalesMan))

i want achieve like below image

tresB — Tue, 06 Oct 2015 08:55:27 GMT

May be like:

= Aggr(If( rank( (sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Inv'},Month,Year=,Quarter=>}$(vSalesBtn))

sum({<Year= {$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType = {'Credit'},Month,Year=,Quarter=>}$(vSalesBtn))))=1,SalesMan),SalesMan)

If this doesn't help, try to share your sample qvw.

stephenedberkg — Tue, 06 Oct 2015 09:09:50 GMT

Thank you