topic Re: Rank Calculations in QlikView

Rank Calculations

vikasmahajan — Thu, 23 May 2013 04:01:39 GMT

Dear All,

I have following expressions for mat sales and monthly sales I want to calculate rank BRAND wise how

do I this can any one give idea ?

Mat Sales Expression

---------------------------------

(sum({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear)),$(=max(FiscalYear)-1)}

,Date={"<=$(=max(Date))>=$(=MonthStart(max(Date),-11))"}>}Values)

)/10000000

Monthly Sales Expression

-------------------------------------

SUM({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear))},MonthNumber = {"<=$(=max({<FiscalYear={$(=max(FiscalYear))}>} MonthNumber))>$(=max({<FiscalYear={$(=max(FiscalYear))}>} MonthNumber)-1)"}>}Values

/10000000)

Thanks in advance.

Vikas

Re: Rank Calculations

sushil353 — Thu, 23 May 2013 04:56:10 GMT

Try this:

aggr(rank(

/10000000)),BRAND)

HTH

Sushil

Re: Rank Calculations

vikasmahajan — Thu, 23 May 2013 06:29:29 GMT

Dear Sushil

Thanks for Reply this expression I applied already results means RANK coming wrong , I think qlikivew is considering zero or null values while calculating rank.

What could be a problem ?

Vikas

Re: Rank Calculations

sushil353 — Thu, 23 May 2013 06:35:05 GMT

could you please update a sample app and explain the output which u want