topic help with expression in QlikView https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319037#M843385 <HTML><HEAD></HEAD><BODY><P>I need to calculate the status by day , if there is one failure per day .. the status is fail ,if all statuses are success then success .. </P><P>so basically i need a new column with one status either fail or success, below is my sample data i am aggregating the data by date and concatenating the status</P><P></P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160067_1.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z help with expression https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319037#M843385 <HTML><HEAD></HEAD><BODY><P>I need to calculate the status by day , if there is one failure per day .. the status is fail ,if all statuses are success then success .. </P><P>so basically i need a new column with one status either fail or success, below is my sample data i am aggregating the data by date and concatenating the status</P><P></P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160067_1.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319037#M843385 Anonymous 2020-11-25T16:16:04Z Re: help with expression https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319038#M843386 <HTML><HEAD></HEAD><BODY><P>May be create one line in script</P><P></P><P><STRONG>If(SubStringCount(DataStatus, 'failure','failure'), 'success')</STRONG></P></BODY></HTML> Fri, 14 Apr 2017 01:40:05 GMT https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319038#M843386 Anil_Babu_Samineni 2017-04-14T01:40:05Z Re: help with expression https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319039#M843387 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><EM>If(SubStringCount(<STRONG>Concat</STRONG>(DataStatus), 'failure<STRONG>'),</STRONG>'failure', 'success')</EM></P></BODY></HTML> Fri, 14 Apr 2017 04:55:00 GMT https://community.qlik.com/t5/QlikView/help-with-expression/m-p/1319039#M843387 tresB 2017-04-14T04:55:00Z