Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

help on set analysi exp

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 I need to show "Fail" only.else remaing 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)

1 Reply
Highlighted
Creator II
Creator II

Re: help on set analysi exp

looks like you need a final parenthesis on the end:

if(count({<MetricName={'M1','M2','M3','M4'},MetricIndexvlaue={'FAIL'},MetricIndexPeriod ={'$(=$(v_previous_month))'}>}Metricvlaue)    >0

,'Fail',

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

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