topic Re: Help needed on Top 5 products in QlikView

Help needed on Top 5 products

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Hope all are doing good !

I am new to Qlikview and i need help on top 5 products.Here is my scenario..

I have a line chart with Month and Products Dimensions and expression to calculate previous 6 months rolling total.

Now i need to display top 5 products sales for past 6 months. i need month on x-axis.

i tried dimension limits for products dimension but no luck. below is the expression i am using.

Sum({<Year=, Quarter=, Month=, Date={">=$(=MonthStart(Max( Date),-5))<=$(=Max( Date)))"}>}Sales

i tried calculated dimension as well with below expression

aggr(If(Rank(Sum({<Year=, Quarter=, Month=, Date={">=$(=MonthStart(Max( Date),-5))<=$(=Max( Date)))"}>}Sales))<=5,Products),Products)

Please help in this regard.

Thanks in advance

Regards,

Chandrika

Re: Help needed on Top 5 products

Chanty4u — Wed, 30 Mar 2016 11:19:38 GMT

chk dis

Re: Set Analysis + Top5

Re: Rank of top 5 products

Re: Help needed on Top 5 products

Kushal_Chawda — Wed, 30 Mar 2016 11:24:07 GMT

try below calculated dimension

aggr(If(Rank(Sum({<Year=, Quarter=, Month=, Date={">=$(=MonthStart(Max( Date),-5))<=$(=Max( Date)))"}>}Sales))<=5,Products),Month,Products)

Re: Help needed on Top 5 products

engishfaque — Wed, 30 Mar 2016 11:24:58 GMT

Dear Chandrika,

Please check listed below link, I hope listed below post will help you.

top 10 customers by their Invoice Amount

Kind regards,

Ishfaque Ahmed

Re: Help needed on Top 5 products

Thu, 31 Mar 2016 06:07:23 GMT

Hi ahamad,

Thanks for the response.

In my scenario. i have two dimensions Month and products.

i have tried dimension limits option but no luck.

Thanks,

Chandrika

Re: Help needed on Top 5 products

Thu, 31 Mar 2016 06:27:14 GMT

Hi Kush,

I have tried the expression that you have provided.But it is returning the products for current month.But i want to show previous 6 months.

Thnanks,

Chandrika

Re: Help needed on Top 5 products

Kushal_Chawda — Thu, 31 Mar 2016 10:44:22 GMT

Can you share the sample?