Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

I need to write following if statements?

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


1 Solution

Accepted Solutions
Contributor III
Contributor III

3 Replies

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

Contributor III
Contributor III


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