Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top N in Pivot/Straight table with multiple dimension

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.

17 Replies
Not applicable
Author

Skhan,

please share qvw or xls with your data sample.

regards

Darek

Anonymous
Not applicable
Author

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
MVP
MVP

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
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Please find the attached for straight table.

Hope it help

Regards

ASHFAQ

Anonymous
Not applicable
Author

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
Specialist
Specialist

Might be helpful

cheers!!!

Not applicable
Author

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?