topic Re: RE:Same Top 10 in QlikView

RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 10:19:28 GMT

hi all,

I have small doubt.

For example i hve top 10 sales 100 for product "A"

and same for top 10 sales 100 for product"B"

i want to get top 10 sales ?

what will be the result?

Re: RE:Same Top 10

sunny_talwar — Mon, 22 Feb 2016 10:20:47 GMT

I don't really understand your question, would you be able to elaborate or share some sample data?

Re: RE:Same Top 10

Anonymous — Mon, 22 Feb 2016 10:24:44 GMT

in dimension limit to give the largest value is 10

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 10:25:03 GMT

hi,

for below i want to get top10sales

product	sales
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10

Re: RE:Same Top 10

kaushiknsolanki — Mon, 22 Feb 2016 10:27:08 GMT

Hi,

When we load this data, because we have only 2 products we will get only top 2 products.

To get top 10 Products.

Just create a straight table with dimension as Product and use dimension limit tab to define top, and give expression as sum(Sales).

Regards,

Kaushik Solanki

Re: RE:Same Top 10

sunny_talwar — Mon, 22 Feb 2016 10:27:34 GMT

Hahahaha they all are the same, so my guess is that they should all be part of top 10 unless you don't want them to be.

Re: RE:Same Top 10

Anonymous — Mon, 22 Feb 2016 10:28:17 GMT

In this case you would be getting only 2 Product sales as you are having a & b product

Re: RE:Same Top 10

sathishkumar_go — Mon, 22 Feb 2016 10:29:13 GMT

you can use rank function to get top values

-Sathish

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 10:30:34 GMT

if i use rank function for both top 10 means.....it will give 11 ?

Re: RE:Same Top 10

sathishkumar_go — Mon, 22 Feb 2016 10:38:41 GMT

not understanding ur requirement properly.

1) You have 2 products each product you want top 10 sales? or u want to see the top 10 products based on the sales?

which is ur requirement?

please post sample data with ur requirement.

-Sathish

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 10:52:34 GMT

not dimension limit.

For example:in same product i hve two top 10 values? which will give the result

Re: RE:Same Top 10

gireesh1216 — Mon, 22 Feb 2016 11:19:10 GMT

hello suri.......

You have two products only.....product A,B

YOU CON'T FIND TOP 10 FOR 2 PRODUCTS

If You Have More then 10 products then only you can find top ten products......

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 11:44:51 GMT

Please look into my data and qvw

in excel sheet 3data

Re: RE:Same Top 10

sunny_talwar — Mon, 22 Feb 2016 11:52:11 GMT

What is the expected output?

Re: RE:Same Top 10

sasikanth — Mon, 22 Feb 2016 11:53:31 GMT

Hi,

What do you want to achieve here?

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 11:55:48 GMT

in my data

i hve emp id 2 and yearsalry is 63000 for both is hvng two records so.. wen i use dimen lim top 5

how it is caluclates?

Re: RE:Same Top 10

sathishkumar_go — Mon, 22 Feb 2016 11:59:49 GMT

Hi,

Please find the below screenshot for using rank function

-Sathish

Re: RE:Same Top 10

sathishkumar_go — Mon, 22 Feb 2016 12:00:42 GMT

=rank(aggr(sum([Year Salary]),Title))

-Sathish

Re: RE:Same Top 10

sathishkumar_go — Mon, 22 Feb 2016 12:01:10 GMT

use if condition for top 5 or 10 values.

-Sathish

Re: RE:Same Top 10

Chanty4u — Mon, 22 Feb 2016 12:07:45 GMT

that is okay. in abve ur screen sht

sales coordinator sum(yearsalary) 65000

if i hve same sales coordinator sum(yearsalary) 65000

what will be the result?