I need to write following if statements?

[dolly777]

Hi All,

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

Thanks

[sunny_talwar]

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

[dolly777 · Accepted solution]

Tq Sunny

[sunny_talwar]

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

Best,

Sunny