Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Not applicable

## TOP <NUMBER> TOTAL in Qlikview

Dear All,

i have table which shows CITY wise TURNOVER of particular selected MEMBER like:

i have Select MEMBER 'A'.

CITY
SUM(TURNOVER)
DELHI100
MUMBAI200
PUNE150

Now my requirement is to get SUM(TURNOVER) of TOP 5 MEMBERS of that CITY. like

i have Select MEMBER 'A'.

CITYSUM(TURNOVER)
TOP 5 MEMBERS OF THAT CITY TURNOVER
DELHI100500
MUMBAI200300
PUNE150550

Kindly let me know how can this possibel

Regards,

JKV

1 Solution

Accepted Solutions
Luminary Alumni

Use this expression.

=sum({1<CITY=P(CITY)>} aggr( if(rank(Sum({1}TURNOVER))<=5, Sum({1}TURNOVER)), CITY, MEMBER))

7 Replies
Not applicable
Author

PFA, use dimension limit.

Creator II

Write a set expression by using rank function include member.

Luminary Alumni

Hi,

If you attach some sample data or some sample file then it would be easier to help you, otherwise no one is interested to prepare data and then give solution.

Qlik Community Tip: Posting Successful Discussion Threads

Not applicable
Author

below is the formula to get the RANK on a city of particular selected Member.

But i want sum of TURNOVER OF top 5 MEMBERS

Not applicable
Author

Dear All Please find attached Excel file for sample table and result table with color indicator

Not applicable
Author

Hi Navdeep,

Thanks for help, but that is not what i need.

the Member is not the part of the dimension in a table its just a part of the selection.

find attached excel sheet that will help you to get what exactly i need

Thanks

Luminary Alumni

Use this expression.

=sum({1<CITY=P(CITY)>} aggr( if(rank(Sum({1}TURNOVER))<=5, Sum({1}TURNOVER)), CITY, MEMBER))

Community Browser