topic Re: Top 10 sales in set analysis in QlikView

Top 10 sales in set analysis

Wed, 25 Nov 2020 16:16:04 GMT

How may i get top 10 sales in set analysis, anyone can u briefly explain it?

Re: Top 10 sales in set analysis

kaushiknsolanki — Mon, 18 Jul 2016 08:07:19 GMT

Hi,

You can use below expression.

Sum({<Product = {'=Rank(Sum(Sales)) <=10'}>}Sales)

Regards,

Kaushik Solanki

Re: Top 10 sales in set analysis

sunny_talwar — Mon, 18 Jul 2016 08:47:15 GMT

I am not 100% confident, but don't we need double quotes around search strings Kaushik?

Sum({<Product = {"=Rank(Sum(Sales)) <=10"}>}Sales)

Re: Top 10 sales in set analysis

kaushiknsolanki — Mon, 18 Jul 2016 08:50:40 GMT

Sunny,

It works for both.

Regards,

Kaushik Solanki

Re: Top 10 sales in set analysis

Mark_Little — Mon, 18 Jul 2016 08:51:10 GMT

Hi,

Another option is if you're doing it in a chart,

Go to the properties > Dimension limits

Mark

Re: Top 10 sales in set analysis

sunny_talwar — Mon, 18 Jul 2016 08:54:59 GMT

I guess, I will have to try out with single quotes because I always thought that we needed double quotes for search string.

Update: I guess this confused me... it works, but as HIC mentioned, it would be a bug which might get fixed (which may never get fixed)

Re: Top 10 sales in set analysis

kaushiknsolanki — Mon, 18 Jul 2016 08:58:36 GMT

May be its right,

But I didnt see any misbehavior of using single quote till now, So wont qualify this as a bug.

Regards,

Kaushik Solanki

Re: Top 10 sales in set analysis

beck_bakytbek — Mon, 18 Jul 2016 12:25:31 GMT

if you can use this:

if(aggr(Rank(Sum(Sales)),Produkt) <=10, Product,Null())

hope that helps

beck

Re: Top 10 sales in set analysis

rwunderlich — Mon, 18 Jul 2016 16:57:40 GMT

It is a "bug", in the sense that the code does not match the published documentation. Single quotes were supposed to mean literals, double quotes search strings. But in the actual implementation, they are interchangeable. This has left us with some oddities like '*' does not search for an asterisk.

I try to code per "the rules", and encourage my students to do so, in the hope that someday we will be able to close this hole.

-Rob

Re: Top 10 sales in set analysis

kaushiknsolanki — Mon, 18 Jul 2016 17:11:27 GMT

Agree with you Rob..

As per the programming standard, this is a bug for sure.

I was just thinking from a non programmers stand..

Regards,

Kaushik Solanki

Re: Top 10 sales in set analysis

Anil_Babu_Samineni — Mon, 18 Jul 2016 18:17:12 GMT

If your answer is solved please close this thread with correct answer

Re: Top 10 sales in set analysis

prasadmundewadi — Mon, 29 Jan 2018 22:08:17 GMT

I have already a complex set analysis and then on top of it want to add the top 10 condition.

e.g. Need to get the sum

Opportunity with the Top 10 Values with below conditions:

1) Status <> Omitted

2) Current Qtr Flag = Y

3) Won flag = Y

Sum({<[Status]-={'Omitted'}, [Current Qtr Flag]={'Y'}, [Won Flag]={'Y'}>} Value)

Now where do i add the Rank in the above set analysis?

Re: Top 10 sales in set analysis

sjaiswal13 — Fri, 15 Mar 2019 21:42:59 GMT

Hi Prasadmundewadi,

Did the rank with all the conditions combination work for you?

Thanks,

Sonam