https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647168#M730361 <P>I have data in the following way</P><P>&nbsp;</P><P><STRONG>ID&nbsp; &nbsp; &nbsp; &nbsp; CatID&nbsp; &nbsp; &nbsp; Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Flag&nbsp; &nbsp;(Expected Field)</STRONG></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete/Pending</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete/Pending</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Pending</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Complete/Pending</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete&nbsp; &nbsp; &nbsp;&nbsp;Complete/Pending</P><P>&nbsp;</P><P>I need to create a new field called 'Flag' that says 'Complete/Pending' for the IDs that has both 'Pending' and 'Complete' in Status. If the ID has only one value in the Status field, then show the same Status value in the 'Flag'</P><P>How do I do this in the script?</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:56:31 GMT qlikwiz123 2024-11-16T01:56:31Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647168#M730361 <P>I have data in the following way</P><P>&nbsp;</P><P><STRONG>ID&nbsp; &nbsp; &nbsp; &nbsp; CatID&nbsp; &nbsp; &nbsp; Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Flag&nbsp; &nbsp;(Expected Field)</STRONG></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete/Pending</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete/Pending</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Pending</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Complete/Pending</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Complete&nbsp; &nbsp; &nbsp;&nbsp;Complete/Pending</P><P>&nbsp;</P><P>I need to create a new field called 'Flag' that says 'Complete/Pending' for the IDs that has both 'Pending' and 'Complete' in Status. If the ID has only one value in the Status field, then show the same Status value in the 'Flag'</P><P>How do I do this in the script?</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:56:31 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647168#M730361 qlikwiz123 2024-11-16T01:56:31Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647187#M730362 <P>Try this :</P><P>TABLE1:</P><P>LOAD ID,&nbsp;</P><P>CatID,</P><P>Status</P><P>from XXXXX.QVD;</P><P>LEFT JOIN (TABLE1)</P><P>load ID,</P><P><SPAN>Concat(distinct Status ,'-' ) as Flag</SPAN></P><P><SPAN>resident TABLE1;</SPAN></P><P>&nbsp;</P><P>Saludos!!!</P> Thu, 14 Nov 2019 20:16:16 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647187#M730362 Marcos_rv 2019-11-14T20:16:16Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647211#M730363 <P>Says Invalid Expression</P> Thu, 14 Nov 2019 21:12:49 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647211#M730363 qlikwiz123 2019-11-14T21:12:49Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647218#M730364 <P>Needed to Group By. Will try. Thanks</P> Thu, 14 Nov 2019 21:47:08 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647218#M730364 qlikwiz123 2019-11-14T21:47:08Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647277#M730365 <P>PFA</P> Fri, 15 Nov 2019 04:47:38 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647277#M730365 Anil_Babu_Samineni 2019-11-15T04:47:38Z https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647517#M730366 <P>yep,&nbsp;</P><P>group by ID;</P><P>&nbsp;</P><P>Very close !! jajaja&nbsp;</P><P>&nbsp;</P> Fri, 15 Nov 2019 14:03:39 GMT https://community.qlik.com/t5/QlikView/Create-a-Flag-in-Script-based-on-Condition/m-p/1647517#M730366 Marcos_rv 2019-11-15T14:03:39Z