Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

gireesh007
New Contributor III

need to show top ten records in pivot

HI everyone,

i need to show only top ten deal number based on opportunity at typical less than 1000K,in pivot table we have to sort in calculated  dimension, Please help me to modify the calculated dimension to get only top ten deal numbers based on [opportunity at typical]

=if(aggr (sum(IF(Guidance_Method_for_APT='MBG',[Net Revenue for Guidance],IF(Guidance_Method_for_APT='DBG',[DBG Net Revenue for Guidance]))), [Deal Number without G])>1000000, null(), aggr(if(-rank($(vExpOppR))<=10 and $(vExpOppR) <> null(),[Deal Number without G],null()),[Deal Number without G]))

!Below attached screen shot

bottom ten deals.png

Regards,

girish

1 Solution

Accepted Solutions
gireesh007
New Contributor III

Re: need to show top ten records in pivot

hi Gysbert,

Thanks for your reply, as per requirement i have to show in pivot table only, so i modified in calculated dimension i got

solution.




Regards,

girish

2 Replies

Re: need to show top ten records in pivot

I don't see a reason why you can't use a straight table instead of a pivot table in this case. When using a straight table you can use Dimension Limits to show only the top 10.


talk is cheap, supply exceeds demand
gireesh007
New Contributor III

Re: need to show top ten records in pivot

hi Gysbert,

Thanks for your reply, as per requirement i have to show in pivot table only, so i modified in calculated dimension i got

solution.




Regards,

girish

Community Browser