topic Re: Aggr help required in QlikView

Aggr help required

kkkumar82 — Fri, 26 Aug 2016 11:35:21 GMT

Hi ,

PFA qvw with some requirements

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 11:41:29 GMT

See if attached is what you wanted

Re: Aggr help required

kkkumar82 — Fri, 26 Aug 2016 12:10:21 GMT

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.

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 12:22:47 GMT

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?

Re: Aggr help required

kkkumar82 — Fri, 26 Aug 2016 12:30:19 GMT

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 ??

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 12:31:51 GMT

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

Re: Aggr help required

kkkumar82 — Fri, 26 Aug 2016 12:47:00 GMT

with in top three per product group

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 12:50:01 GMT

Try this:

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

Re: Aggr help required

kkkumar82 — Fri, 26 Aug 2016 13:46:44 GMT

Thanks Sunny it worked

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 13:47:34 GMT

Chak de phatte

Re: Aggr help required

kkkumar82 — Fri, 26 Aug 2016 13:50:17 GMT

milenge tho chakdenge, kab miloge

Re: Aggr help required

sunny_talwar — Fri, 26 Aug 2016 13:52:35 GMT

You never know when our paths might cross. I will look forward for that time