Skip to main content
Announcements
The New Qlik Learning Experience is Here! GET STARTED
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of Account Balances of Top N accounts

Hi, I am trying to create the chart to show the sum of account balances of top N accounts. I need to create the below chart. If I select any date , I want show the chart like below:

Top 5 --> Sum of Top 5 Account Balances

Top 5 Accounts --> List of Accounts Top 5 Accounts List (EX: 2, 5, 8, 20, 4)

TOP 5TOP 5 AccountTop 10Top 25Top 75
MonthEnd
QTD
PQTD
P2QTD
YTD

Please find the attached sample QVD file for sample data.

7 Replies
Not applicable
Author

Any Help ?

Anonymous
Not applicable
Author

I didn't want to downloaded you data, sorry...  See a simple example attached.  It will be easy to apply the same rules to all your expressions.

Not applicable
Author

Hi Mike Thanks for the reply. I am encountering two probelms.

1. I want show only 5 Accounts. Example for 12/13 it was showing 6 accounts. How to give the unique ranking if the rank value matching.

2. I want show MonthEnd (Total Month), QTD , PQTD (Previous Quarter) , P2QTD (Previous 2 Quarters) and YTD value for selected date

Please find the attached sample data.

preminqlik
Specialist II
Specialist II

hi dude,

Am attaching a doccument  for only top 5 accoounts

Not applicable
Author

I have very huge data and your expression went out of memory.

I am looking for how to give unique ranking if the value matching

Not applicable
Author

Use Dimension limits and select show only 5 higest values

Capture.PNG.png

and remove selection "show others"

Not applicable
Author

I want show Top 5 accounts in one cell value like : 10, 45, 67, 2, 23