topic Re: Set Analysis Help in QlikView

Set Analysis Help

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

Hi All, I need help on this below set analysis.

All I need is for few of the column I need to show "PASS" or "Fail" based on Metricvlaue .

If any of the value contains "Fail" I need to show "Fail" only.else remaining values. somehow it is not working.

if(count(

{<MetricName={'M1','M2','M3','M4'},

MetricIndexvlaue={'FAIL'},MetricIndexPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)>0,'Fail','PASS'),

sum({<MetricPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)

/count({$<MetricPlant-={'M6'}>}distinct MetricPlant)

Muthu — Fri, 07 Jul 2017 08:30:09 GMT

Please attach sample qvw.

Anonymous — Fri, 07 Jul 2017 08:39:46 GMT

MetricID,Metricvalue,Matericperiod

M1,PASS,JUN2017

M1,PASS,MAY2017

M2,10,JUN2017

M2,20,MAY2017

M3,30,JUN2017

M3,40,MAY2017

M4,PASS,JUN2017

M4,FAIL,MAY2017

Here for M1 AND M4 need to show "fail" even if there is Fail.else "Pass". also sum(MetricValue) for remaining metricIDs

Hope this can give you idea

sunny_talwar — Fri, 07 Jul 2017 08:41:08 GMT

Your if condition ended here, what is the part in red below?

if(count(

{<MetricName={'M1','M2','M3','M4'},

MetricIndexvlaue={'FAIL'},MetricIndexPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)>0,'Fail','PASS'),

sum({<MetricPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)

/count({$<MetricPlant-={'M6'}>}distinct MetricPlant)

Anonymous — Fri, 07 Jul 2017 09:35:09 GMT

Hi Sunny,

Its kind of MetricName-={'M1','M2','M3','M4'} Means am excluding the other Metrics. Because other metrics will have the numeric values

Anonymous — Fri, 07 Jul 2017 09:58:27 GMT

Hi its my original expression

if(v_set_reset=0 and GetSelectedCount(MetricIndexPeriod)=0,

IF(count({<Pvt_MetricName={'M1','M2','M3','M4'},

MetricIndexvlaue={'FAIL'},MetricIndexPeriod = {'$(=$(v_previous_month))'}>}MetricIndexvlaue)>0,'Fail','PASS',

(sum({<MetricIndexYear = {'$(=$(v_previous_year))'}>}MetricIndexvlaue)/12

),IF((v_set_reset=1 or v_set_reset =0) and GetSelectedCount(MetricIndexPeriod)>0,

count({<Pvt_MetricName={'M1','M2','M3','M4'},

MetricIndexvlaue={'FAIL'},MetricIndexPeriod = {'$(=$(v_previous_month))'}>}MetricIndexvlaue)>0,'Fail','PASS'),sum(MetricIndexvlaue)))