topic Re: Top 10 sales in QlikView

Top 10 sales

Thu, 03 Apr 2014 13:33:20 GMT

Hi Guys ,

I have a table

Sno product sales

1 P 100

2 Q 150

3 R 110

4 P 200

5 Q 170

6 P 240

7 P 160

Like this i haev number of rows , now my Question is

I want to caluculate Top 10 sales of product='P' in a chart , Can anybody please assist me on this

Thanks

Nani

Re: Top 10 sales

sudeepkm — Thu, 03 Apr 2014 13:47:56 GMT

Please take a look at the example.

Re: Top 10 sales

Thu, 03 Apr 2014 13:56:57 GMT

Thanks sudeep,

But in my case i have to show two exp in a pie chart like below

1) Top ten sales of a product 'p'

2)sales of remaining products

Only exp i have to use here no dimensions ..

Thanks

Nani

Re: Top 10 sales

Fri, 04 Apr 2014 05:58:54 GMT

Can any one plese assist me on this...

Re: Top 10 sales

neha_shirsath — Fri, 04 Apr 2014 06:55:27 GMT

Hi Nani Dhulipala,

Please find the attached sample Test application.

Hope it is what you are expecting.

-Regards,

Neha

Re: Top 10 sales

Fri, 04 Apr 2014 07:13:21 GMT

Thanks for the reply Neha

Here is my Question

i want to write 2 exp in pie chart

1)top ten sales of product 'P'

2) remaining sales of prodct 'P' only

Regards

Nani

Re: Top 10 sales

senpradip007 — Fri, 04 Apr 2014 07:23:56 GMT

Hi Nani,

I hope you are trying to display the top 10 sales of product 'P' and other than top 10 sales of the same.

In pie chart only one expression can be plotted at a time. To get this you can use Conditional Expression.

Hope it will help you.

Regards.

Re: Top 10 sales

nizamsha — Fri, 04 Apr 2014 07:25:01 GMT

= if(rank(sum({$<product={"P"}>}sales))<10,sum({$<product={"P"}>}sales))

Re: Re: Top 10 sales

sudeepkm — Fri, 04 Apr 2014 10:47:38 GMT

Please take a look at the example. I've done it for top 4 but you can change it to top 10.

I'm still looking to make it little more optimized.

Re: Top 10 sales

arjunkrishnan — Fri, 04 Apr 2014 11:44:37 GMT

Hai Nani,

If(Rank(Sum({<[product ]={'P'}>}Sales),10)<=10,Sum({<[product ]={'P'}>}Sales))