topic Re: If statement help please. in QlikView

If statement help please.

Mon, 03 Feb 2014 15:45:08 GMT

Sum (if(ActualAccount<>0,
if([Miscellenious Fee]<>0,
if(year=, Month=, Date=('>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))')),FeeAmount)))
Am I doing anaything wrong here ?

I want to calculate the sum of FeeAmount if ActualAccount <>0 and if [Miscellenious Fee]<>0 for previous month.

I tried below set analysis expression for previous month calculation and it works fine.

{<Year =, Month=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>}

I want to put this in if statement instead of set analysis.Please help me.

Thanks a lot.

Re: If statement help please.

jerem1234 — Mon, 03 Feb 2014 15:50:33 GMT

Try:

Sum ({<Year =, Month=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>}if(ActualAccount<>0 and [Miscellenious Fee]<>0,
FeeAmount))

Hope this helps!

Re: If statement help please.

Mon, 03 Feb 2014 15:57:17 GMT

Jerem,Awesome.Thank you.