17 Replies Latest reply: Apr 23, 2014 6:18 AM by Tresesco B RSS

    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.