wtd lwtd comparsion

Fri, 17 Jul 2015 06:12:02 GMT

I ma facing problem while calculating

(WTD/LWTD-)1 i.e. growth over last year

I am using this experssion

Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(MonthStart(Max(WalkinDateNum))))<=$(=Max(WalkinDateNum))"}>} Incount)+

Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(MonthStart(Max(WalkinDateNum))))<=$(=Max(WalkinDateNum))"}>} OutCount))/2))/

(Count(distinct {<PostingDateNum={'>=$(vPriorMinDate)<=$(vPriorMaxDate)'}, Year=,Num_Month=>} if(TrnType='2100',Bill_No_Distinct))

/

((Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(YearStart(vMinPriorWalkin)))<=$(=(vMaxPriorWalkin))"}>} Incount)+

Sum({<Year=, Num_Month=, Week=, [Walkin Date]=, WalkinDateNum={">=$(=Num(YearStart((vMinPriorWalkin))))<=$(=(vMaxPriorWalkin))"}>} OutCount))/2)))

-1,

Re: wtd lwtd comparsion

Fri, 17 Jul 2015 09:22:40 GMT

Parenthesis are not opened/closed properly at /2. Correct that and post the changed expression if it still does not work. Upload sample QVW for better understanding and quick resolution.

Regards,

KKR

topic Re: wtd lwtd comparsion in QlikView

wtd lwtd comparsion

Re: wtd lwtd comparsion