Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple if statements with variable dates


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