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

straight table query in total sum

     hi all,

while selecting top 10 in straight table, the Expression total is showing complete total rather than top 10 total. how to resolve this?

table structure is simple 1 column as client name and 2 nd column as revenue $ value

please advise

thanks

sukhwant


1 Solution

Accepted Solutions
ecolomer
Master II
Master II

See this

=if(aggr((Rank(SUM(Sales),0,1)),[Branch Code],[Sales Operator])<= 5, [Branch Code])

p09.png

View solution in original post

11 Replies
ecolomer
Master II
Master II

An example to see ....

Anonymous
Not applicable
Author

Hello Sukhwant,

Do You have some image or sample data ?

Morandi

Not applicable
Author

sorry no developer license, so can't open attachment

maxgro
MVP
MVP

are you using dimension limit for top?

Not applicable
Author


hi ,

data can be

Client name     value

1                    50

2                    40

3                    30

4                    20

5                    10

6                    50

so when i say top 5 in presentation tab, and expression of value as "sum of rows", i should get total as 150, but i am getting 200

please advise

thanks

maxgro
MVP
MVP

different ways to get top

Show Top Performers | Qlik Community

Not applicable
Author

Properties - presentation - max num (1-100) - 5

jyothish8807
Master II
Master II

Hi,

Try

sum(aggr(rank(revenue)<=5,revenue))

Regards

KC

Best Regards,
KC
anbu1984
Master III
Master III

Use calculated dimension to restrict number of dimensions which will give you correct total

=If(Aggr(Rank(Sum(value)) <= 5,[Client name]),[Client name])