Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple if statements with variable dates

Hello,

I am trying to create an expression that will do the following:

1.) If the Report_Month equals the current month (vCurrentMonth) or later it will return the budget for the month. 

     The formula for my budget is as follows: sum([Revised Month Liq])*sum([$Accts])/sum(total<Portfolio>[$Accts])

2.) If the Report_Month equals the [Recall Date] or later I would like for it to return: sum([Revised Month Liq])*(Percentage/100)

here is the current expression:

if(Report_Month>=vCurrentMonth,sum([Revised Month Liq])*sum([$Accts])/sum(total<Portfolio>[$Accts]),if(Report_Month>=[Recall Date],sum([Revised Month Liq])*(Percentage/100)))


Any help would be greatly appreciated!

0 Replies