https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771395#M717670 <P>Hi community any help on my post ???</P> Thu, 31 Dec 2020 15:41:30 GMT smilingjohn 2020-12-31T15:41:30Z https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771342#M717669 <P>Hi Commu....</P><P>Thanks in Advan</P> Mon, 04 Jan 2021 06:18:44 GMT https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771342#M717669 smilingjohn 2021-01-04T06:18:44Z https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771395#M717670 <P>Hi community any help on my post ???</P> Thu, 31 Dec 2020 15:41:30 GMT https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771395#M717670 smilingjohn 2020-12-31T15:41:30Z https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771403#M717671 <P>May be remove the Pick(match()) around.. I meant like this</P><P>if(Aggr(Count(DISTINCT Product_Tower),Product_Tower)&gt;0,<BR />if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap and WildMatch(LABEL,'*NoMode*')&gt;0,JIRA_KEY_ID)),[Sub-Capabilites])&gt;0,'R',<BR />if(aggr(count(Distinct if([Sub-Capabilites]=Sub_Cap ,JIRA_KEY_ID)),[Sub-Capabilites])&gt;0,'G',<BR />if(aggr(count(Distinct if(WildMatch(LABEL,'*NoMode*')&gt;0,JIRA_KEY_ID)),Capabilites)&gt;0,'R',<BR />if(aggr(count(Distinct JIRA_KEY_ID),Capabilites)&gt;0,'G','B')))))</P> Thu, 31 Dec 2020 17:18:09 GMT https://community.qlik.com/t5/QlikView/Cal-di/m-p/1771403#M717671 Anil_Babu_Samineni 2020-12-31T17:18:09Z