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: 
kkkumar82
Specialist III
Specialist III

Aggr help required

Hi ,

PFA qvw with some requirements

1 Solution

Accepted Solutions
sunny_talwar

See if attached is what you wanted

View solution in original post

11 Replies
sunny_talwar

See if attached is what you wanted

kkkumar82
Specialist III
Specialist III
Author

Thanks sunny,

One more question

I want to find Difference of Sales for each SalesmanID with in a productID with the lowest in the ProductID, Can you please look into it.

sunny_talwar

I see that you have dimension limits in your straight table. What is the exact output you are looking for? Can you provide the expected output in an Excel file?

kkkumar82
Specialist III
Specialist III
Author

The requirement is the table should show the top three salesmanID and they wants to see the difference of their sales for each product group with the lowest salesmanID.

Is it not possible with Dimension limits ??

sunny_talwar

When you say lowest, is it the lowest from the complete list of SalesmanID or lowest within the top three

kkkumar82
Specialist III
Specialist III
Author

with in top three per product group

sunny_talwar

Try this:

Sum(Sales) - Min(TOTAL <[Product ID]> Aggr(If(Rank(Sum(Sales)) < 4, Sum(Sales)), [Product ID], [Salesman ID]))

Capture.PNG

kkkumar82
Specialist III
Specialist III
Author

Thanks Sunny it worked

sunny_talwar

Chak de phatte