Expression convert to SET Analysis

[grakeshqvd]

=num(Count(if(ReviewInMonth='Y' and WildMatch(ArrangeName,'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism,'BUSINESS REQUIREMENTS Mechanism,'FUNCTIONAL REQUIREMENTS Mechanism,'MINOR DEVELOPMENT DOCUMENT Mechanism,'SCOPE DOCUMENT Mechanism) AND wildmatch(MutualStatus,'Reviewed-MTD','Open*','Resolved*'),PMKey)),'#,##0')

How to convert above expression in to SET Analysis. Please help me.

[Anonymous]

Hi you could create two flags in your load script for ArrangeName and MutualStatus such

if(wildmatch(ArrangeName,'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism,'BUSINESS REQUIREMENTS Mechanism,'FUNCTIONAL REQUIREMENTS Mechanism,'MINOR DEVELOPMENT DOCUMENT Mechanism,'SCOPE DOCUMENT Mechanism),'Y','N') as ArrangeName_Flag

and

if(wildmatch(MutualStatus,'Reviewed-MTD','Open*','Resolved*'),'Y','N')as MutualStatus_Flag

Then in your expression would just be

num(Count({<[ReviewInMonth]={'Y'}, ArrangeName_Flag={'Y'},MutualStatus_Flag={'Y'}>}PMKey),'#,##0')

[jonathandienst]

Like this:

Count({<ReviewInMonth = {Y},

    ArrangeName = {'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism',

        'BUSINESS REQUIREMENTS Mechanism', 'FUNCTIONAL REQUIREMENTS Mechanism',

        'MINOR DEVELOPMENT DOCUMENT Mechanism', 'SCOPE DOCUMENT Mechanism'},

    MutualStatus = {"Reviewed-MTD", "Open*", "Resolved*"}

>} PMKey)

[sunny_talwar]

You might have missed a single quote

Count({<ReviewInMonth = {Y}, ArrangeName = {'BR/FR Mechanism','SCOPE DOCUMENT AND TEST PLAN Mechanism',

        'BUSINESS REQUIREMENTS Mechanism', 'FUNCTIONAL REQUIREMENTS Mechanism',

        'MINOR DEVELOPMENT DOCUMENT Mechanism', 'SCOPE DOCUMENT Mechanism'},

   MutualStatus = {"Reviewed-MTD", "Open*", "Resolved*"}

>} PMKey)