topic Find Top Selling Product in QlikView

Find Top Selling Product

Fri, 28 Aug 2015 03:50:39 GMT

hello Dears

1-I want find Top 5 Selling Product (Sum(SaleAmount))?

2-i want find largest Product Per SubCategory (Sum(SaleAmount))

Look Like

plz help me

settu_periasamy — Fri, 28 Aug 2015 04:43:39 GMT

Hi,

Can you try this in your Expression...

=if(rank(Sum(SalesAmount))<=5,sum(SalesAmount))

mightyqlikers — Fri, 28 Aug 2015 04:57:09 GMT

PFA

Regards

Sam

kavita25 — Fri, 28 Aug 2015 05:06:17 GMT

Try the below logic:

In calculated dimension

=AGGR(IF(Rank(sum(SalesAmount), 4)<=5, EnglishProductSubcategoryName), EnglishProductSubcategoryName)

with the same expression

Regards,

Kavita

Fri, 28 Aug 2015 05:13:14 GMT

Thanks

now if want find worst Sum(SaleAmount) Per Subcategory ?How

Fri, 28 Aug 2015 07:08:29 GMT

Thanks

now if want find worst Sum(SaleAmount) Per Subcategory ?How

Fri, 28 Aug 2015 07:09:06 GMT

jagan — Fri, 28 Aug 2015 07:29:18 GMT

Hi,

Try like this

Dimension: EnglishProductSubcategoryName

Expression:=Aggr(if(rank(-sum({<SalesAmount ={'>0'}>}SalesAmount)) <= 5, sum({<SalesAmount ={'>0'}>} SalesAmount)),EnglishProductSubcategoryName)

Regards,

Jagan.

Fri, 28 Aug 2015 07:35:30 GMT

i try but Expression Is Not Valid