topic expression help- quarter in QlikView

expression help- quarter

Thu, 03 Dec 2015 11:05:21 GMT

Hi Experts,

i have the below expression:

NUM(rank(-(aggr(

(Sum({<MonthYear =,Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>} UnitSales)

Sum({<MonthYear =,Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>} TotalSales))

(Sum({<MonthYear =,Date= {'>=$(=Date(MONTHSTART(AddMonths(vMaxSalesDate, -1))))<=$(=Date(MONTHEND(AddMonths(vMaxSalesDate, -1))))'} >} UnitSales)

Sum({<MonthYear =,Date= {'>=$(=Date(MONTHSTART(AddMonths(vMaxSalesDate, -1))))<=$(=Date(MONTHEND(AddMonths(vMaxSalesDate, -1))))'} >} TotalSales))

, Branch))

))

the expression calculates rank of sales % - Current month vs Previous month.

this woks fine for monthly selection.

but when a quarter is selected, the value is not getting changed.

for ex., if i click on Q4, the expression shows rank for current month and not for the quarter.

how can i change the expression for a quarterly view.

Pls help.

Re: expression help- quarter

Anonymous — Thu, 03 Dec 2015 11:10:28 GMT

Becoz you have bypassed the Date= and quarter you have created on Date field, I hope so..

Re: expression help- quarter

Thu, 03 Dec 2015 11:19:35 GMT

Hi,

thanks for the reply

sorry i dont understand

Can you please help me with the expression change for quarter

Re: expression help- quarter

Thu, 03 Dec 2015 13:57:17 GMT

Pls somebody give suggestions

Re: expression help- quarter

Gysbert_Wassenaar — Thu, 03 Dec 2015 18:12:20 GMT

Try:

NUM(rank(-(aggr(

(Sum({<MonthYear =,Date= {">=$(=QuarterStart($(vMaxSalesDate)))<=$(vMaxSalesDate)"}>} UnitSales)

Sum({<MonthYear =,Date= {">=$(=QuarterStart($(vMaxSalesDate)))<=$(vMaxSalesDate)"}>} TotalSales))

(Sum({<MonthYear =,Date= {'>=$(=QuarterStart($(vMaxSalesDate), -1))<$(=QuarterStart($(vMaxSalesDate)))'} >} UnitSales)

Sum({<MonthYear =,Date= {'>=$(=QuarterStart($(vMaxSalesDate), -1))<$(=QuarterStart($(vMaxSalesDate)))'} >} TotalSales))

, Branch))

))

Re: expression help- quarter

Fri, 04 Dec 2015 14:46:15 GMT

gysbert,

thanks for the reply.

actually for a quarter, i shouldnt change the calculation as current quarter - prev quarter.

i should do quarter with logic curr month - prev month.

i have posted sample in thread 926337.

pls help me on that