# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:  MVP

## Rank Calculations

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)

Vikas

3 Replies  Master II

Try this:

aggr(rank(

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

/10000000)),BRAND)

HTH

Sushil  MVP
Author

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  Master II

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