topic Re: Expression convert to SET Analysis in QlikView

Expression convert to SET Analysis

grakeshqvd — Wed, 25 Nov 2020 16:16:04 GMT

=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.

Re: Expression convert to SET Analysis

Anonymous — Wed, 08 Aug 2018 10:56:55 GMT

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')

Re: Expression convert to SET Analysis

jonathandienst — Wed, 08 Aug 2018 10:58:26 GMT

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)

Re: Expression convert to SET Analysis

sunny_talwar — Wed, 08 Aug 2018 11:11:42 GMT

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)