Discussion board where members can get started with QlikView.
This is the correct logic for the Forecast Category V2:
If Forecast Catergory in (Commit, Omitted,Upside,Won) then Forecast Catergory
If Forecast Catergory in (Pipeline ) then (if SalesStage in (01 - Understand Customer,02 - Validate Opportunity) then ‘Early Stage Unflagged’ else
if SalesStage in (03 - Qualify the Opportunity,04A - Develop Solution,4B - Propose Solution,05 - Negotiate & Close) then ‘Late Stage Unflagged’
How to write above if statements in qlikview script ? Could please give me some suggestions
View solution in original post
May be this
If(Match([Forecast Catergory], 'Commit', 'Omitted', 'Upside', 'Won'), [Forecast Catergory],
If([Forecast Catergory] = Pipeline,
If(Match(SalesStage, '01 - Understand Customer', '02 - Validate Opportunity'), ‘Early Stage Unflagged’,
If(Match(SalesStage, '03 - Qualify the Opportunity', '04A - Develop Solution', '4B - Propose Solution', '05 - Negotiate & Close'), ‘Late Stage Unflagged’)))) as NewField
Awesome, I am glad I was able to help.
Also, if my response helped you get to what you wanted, I would suggest you to mark my response as correct and/or helpful so that future visitors can benefit from it as well.
Qlik Community Tip: Marking Replies as Correct or Helpful