topic Re: Aggr in QlikView

Aggr

Wed, 05 Jun 2013 12:36:12 GMT

m having 2 dimensions and 1 expression,

Branch

company

Sum

i need Branchwise top 10 companies,

m using calculated dimension as =aggr(if(rank(sum(FST_LOAN_AMT)/Denominator)<=11, COMP_NAME),COMP_NAME)

whn i select specific branch, this exp works n i get top 10 comp for each branch ,

but whn i select date calender, it shows less records or it automatically eliminates some of the records,

anybody please help me out into this,

i know thr is some problem with the aggr function used.

Re: Aggr

Thu, 06 Jun 2013 03:58:52 GMT

anybody pls share ur inputs on this..

Re: Aggr

Siva_Sankar — Thu, 06 Jun 2013 04:09:48 GMT

can you share the qvw ?

Re: Aggr

Thu, 06 Jun 2013 04:12:09 GMT

Sorry cant do tht,....

Re: Aggr

Thu, 06 Jun 2013 05:23:35 GMT

if i want to include CYTM flag into this hw cn i do tht,

reason it will cut the dependency from the calender and only show current yr this month data.

Re: Aggr

Thu, 06 Jun 2013 05:57:21 GMT

anybody.........

Re: Aggr

Anonymous — Thu, 06 Jun 2013 13:58:32 GMT

Hello,

what you do is a top 10,

right click on the table, tab Presentation

Re: Aggr

Fri, 07 Jun 2013 04:19:31 GMT

hw cn tht be possible in pivot,

i want top 10 companies branchwise,

i.e

Delhi + top 10 comp + then the respective amt

Mumbai + top 10 comp + then the respective amt

bangalore + top 10 + then the respective amt

... same way for all the branches on the basis of sanctioned amt..

Re: Aggr

Fri, 07 Jun 2013 04:44:45 GMT

thnks mohit for reply,

used both the ways,

1. aggr with the date field, it exceeds allocated memory of the object

2. same o/p which m getting by my expression,

m not able to understand y its skipping the some of the records in for top 10,

can u let me know some way so tht i can incluide the current month (MTD) flag defined in the script in the expression, thn might work out....

need ur inputs.

Re: Aggr

Thu, 08 Jan 2015 18:07:18 GMT

Hi,

i think it should rank out Branch and then AGGR on Branch,Company.

=Aggr(if(rank(SUM)<=10,Branch,0),Branch,Company)

Thanks

Rajesh

Re: Aggr

Thu, 08 Jan 2015 18:10:40 GMT

SUM=Aggr(if(rank(SUM)<=10,Branch,0),Branch,Company)

RANK=Aggr(if(rank(SUM)<=10,Branch,0),Branch,Company)