Discussion Board for collaboration related to QlikView App Development.
m having 2 dimensions and 1 expression,
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.
anybody pls share ur inputs on this..
can you share the qvw ?
Sorry cant do tht,....
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.
what you do is a top 10,
right click on the table, tab Presentation
hw cn tht be possible in pivot,
i want top 10 companies branchwise,
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..
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.
i think it should rank out Branch and then AGGR on Branch,Company.