Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying sum of top 10 values and Filtering based on Threshhold

Hi Experts:

I have 3 simple requirements

1- Enter a Treshhold Value (%) : Beside this text object there should be an input box or text box (i am not sure which is the best option..hence, have not added any object)..... if i enter 10 in the textbox/input box, the sales figures should be divided by 10 in the adjacent table

2- The sum of top 10 values from the table should be shown in the text object beside 'top 10 sales'


thanks a ton in advance

1 Solution

Accepted Solutions
Master III
Master III

Here it is

See the attachment

View solution in original post

8 Replies
Specialist III
Specialist III

Dear YOusuf,

Kindly find the attachment.

I hope it will help you.

Thanks,

Mukram

Not applicable

Hi Mohammad,

Thanks for your prompt reply.

The first ask is done. However, i believe you misunderstood the 2nd ask.

I just want the sum of sales for the top 10 sales to be displayed in text object.

Master III
Master III

Here it is

See the attachment

View solution in original post

Not applicable


Thanks.

one final query. Suppose we dont have any variable. and we just need to display sum of top 10 values from the table and our table has 15 sales person. Then what would be the expression?

Not applicable


In Other words, i just have a table and just a text object in which i have to display the sum of top 10 sales.

MVP
MVP

Use below expression...

=SUM(Aggr(IF(Aggr(Rank(SUM(Sales)),[Sales Person Name])<=10,SUM(Sales)),[Sales Person Name]))

Instead of 10, you can create an input variable with vTOP and use $(vTOP).

=SUM(Aggr(IF(Aggr(Rank(SUM(Sales)),[Sales Person Name])<=$(vTOP),SUM(Sales)),[Sales Person Name]))

I haven't taken threshold value.. Please add yourself as your requirements.

Hope this help.

Specialist
Specialist

1. yes use Input box.

2. use Rank function  aggr(if(Rank(sum(Value)<=10),sum(Values),yourdimension)

anant

Not applicable

Thanks Manish..