Top N in Pivot/Straight table with multiple dimension

[#1]

Hi All,

I am sorry for asking this question which has been mentioned many times in community but the problem is that i simply can't apply those solution as i am newbie in QlikView.

In my situation i have one pivot table which shows the Bank Branch name, its account numbers and respective balance of each account. now i want to display the top 10 balances and their account holder in table , don't know that it should be pivot table or straight table can do this? in future i also want to add the account type in the list. So please guide me how to achieve this?

As mentioned in Excel, i want to have e.g. top 3 account holders, balance wise.

[#2]

Skhan,

please share qvw or xls with your data sample.

regards

Darek

[Anonymous]

You can use the straight table.

Go to "Dimension Limits".Here you can restrict the values.

Let me know if this doesn't worked

[tresesco]

If you use straigth table you get 'Dimension Limit' in it, that makes it easier for you to show the top N values. The similar can be achieved using Pivot table as well with an overhead of complexer expression which would probably require Aggr() and Rank(). Hence, if you don't need pivot for a reason go with straigth table and use dimension limit.

[nilesh_gangurde]

HI,

please have a look on below points,

1.  You can use the Straight table for this and the Dimension Limit tab will help you.

2. or you can write the Expression for top values.

3. if you want to do it with the pivot table then you have to use the Aggr() function in the expression.

-Nilesh

[#6]

i will really appreciate if you can quote an example based on my scenario.

[ashfaq_haseeb]

Hi,

Please find the attached for straight table.

Hope it help

Regards

ASHFAQ

[Anonymous]

Hi skhan

Pls check this word document,where in I have imported your data in to a table and restricted only the Top 10.

Let me know if this helps

TR

Jeba

[qlikpahadi07]

Might be helpful

cheers!!!

[#10]

Thanks a log Ashfaq. but can you convert this to pivot table. e.g. if user want to first see the branch and when it expands it has to see the top 5 accounts and their balances?