Expression Logic

sona_sa — Sat, 18 Apr 2015 11:43:40 GMT

Hi,

I have a pivot object. For data I have attached xls file, Please check. Now the issue is, For Total ODE --> ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion. My Calulation is not correct, Where In My Expression it is calculating like -->

ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion + Exchange (Gain) / Loss + Bad Debts (Which is wrong). It should be like --> ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion.

Expression :-

if(Match($(CurrentMonth),1),

if(match(Summury_Line_No,390), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),21))/((above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),20))+above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),24)),

if(match(Summury_Line_No,400), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),22))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),14)),

if(match(Summury_Line_No,410), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),23))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),11)),

if(match(Summury_Line_No,380), (((above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),24) )+(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),25)))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),27)))*100,

(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]))/100000)

)))

if(match(Summury_Line_No,390), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),21)+above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),21))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),17)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),17)),

if(match(Summury_Line_No,400), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),22)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),22))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),12)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),12)),

if(match(Summury_Line_No,410), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),23)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),23))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),9)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),9)),

if(match(Summury_Line_No,380), (((above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),24) - above(sum({<[Display Year]={$(PreviousYear)}, [Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),24))+(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),25)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),25)))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),27)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),27)))*100,

(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance])-sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]))/100000)

)))

)

Please suggest what should to do.

Thanks.

Re: Expression Logic

sona_sa — Wed, 22 Apr 2015 06:23:09 GMT

Any expectation.

topic Re: Expression Logic in QlikView

Expression Logic

Re: Expression Logic