topic Re: avg? in QlikView

avg?

Anonymous — Wed, 07 Jan 2015 09:35:31 GMT

Hi i have table like

products,amount

apple,100

banana,200

orange,300

finapple,100 like this i have 100 rows of data

i want top 5 and top 10 avg sales

give me expr?

giakoum — Wed, 07 Jan 2015 09:37:38 GMT

in a chart?

use avg(amount) as expression

products as dimension

and use the dimension limit tab to limit it to the first 5 or 10

Wed, 07 Jan 2015 09:40:03 GMT

thats ok fine instead of using dimension limit i want write a expression

mdmukramali — Wed, 07 Jan 2015 09:45:34 GMT

Dear,

Use can use

=Sum({<Products = {"=Rank(Sum(amount)/ Sum(TOTAL amount))<=5"}>} amount) / Sum(TOTAL amount)

giakoum — Wed, 07 Jan 2015 09:45:42 GMT

An expression in a text object for example, will return a single number. What is it exactly that you want to do?

Wed, 07 Jan 2015 09:47:27 GMT

try this,

=if(rank(avg(sales))<=5,avg(sales))

Anonymous — Wed, 07 Jan 2015 10:06:07 GMT

here i am getting other record names also including top5

for top5 i can see bars

but for rest of the things i am getting products name , i want remove all things i want see only top 5 in the chart

giakoum — Wed, 07 Jan 2015 10:27:56 GMT

=if(rank(avg(sales))<=5,avg(sales),null())

and use suppress missing

Wed, 07 Jan 2015 10:48:41 GMT

=avg({<products={"=rank(avg(amount))<=5'}>}amount)