topic Logical Condition in Script in QlikView https://community.qlik.com/t5/QlikView/Logical-Condition-in-Script/m-p/1751415#M453627 <P>Hello everyone,</P><P>Need your help to find out this logical condition on script.</P><P>Perference:</P><UL><LI>First Preference on Category : Supply Issue</LI><LI>Second Preference on Category : forecast</LI><LI>Third Preference on Category : Others categories</LI></UL><P>Check 1 :Per OrderLine, check category with given preference.&nbsp;</P><P>Check 2 :Per OrderLine, check category with given preference. If same category more than 1 then check into OrderNo counts. Maximum no. of counts should be output</P><P>We have the raw data like below:</P><TABLE><TBODY><TR><TD>OrderLine</TD><TD>Parts</TD><TD>Category</TD><TD>OrderNo</TD></TR><TR><TD>CET0578</TD><TD>P19</TD><TD>forecast</TD><TD>100</TD></TR><TR><TD><FONT color="#00FF00"><STRONG>CET0578</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>P05</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>Supply Issue</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>304</STRONG></FONT></TD></TR><TR><TD><FONT color="#FF6600"><STRONG>NIM0578</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>P24</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>forecast</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>304</STRONG></FONT></TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>invalid reason code</TD><TD>246</TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>supplier issue</TD><TD>304</TD></TR><TR><TD>PCT0020</TD><TD>P07</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD>PCT0020</TD><TD>P92</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD>PCT0020</TD><TD>P72</TD><TD>forecast</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P30</TD><TD>invalid reason code</TD><TD>564</TD></TR><TR><TD>PCT0020</TD><TD>P63</TD><TD>invalid reason code</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P14</TD><TD>supplier issue</TD><TD>564</TD></TR><TR><TD>PCT0020</TD><TD>P41</TD><TD>supplier issue</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P10</TD><TD>Supply Issue</TD><TD>290</TD></TR><TR><TD>PCT0020</TD><TD>P90</TD><TD>Supply Issue</TD><TD>290</TD></TR><TR><TD><FONT color="#00FFFF"><STRONG>PCT0020</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>P56</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>Supply Issue</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>564</STRONG></FONT></TD></TR><TR><TD>PCT0950</TD><TD>P02</TD><TD>forecast</TD><TD>200</TD></TR><TR><TD>PCT0950</TD><TD>P06</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD><FONT color="#0000FF"><STRONG>PCT0950</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>P05</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>forecast</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>938</STRONG></FONT></TD></TR><TR><TD>PCT0950</TD><TD>P04</TD><TD>invalid reason code</TD><TD>938</TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P22</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>Daily</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>370</STRONG></FONT></TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P31</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>Maintenance</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>938</STRONG></FONT></TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P19</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>NA</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>938</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Output result:</P><TABLE><TBODY><TR><TD>OrderLine</TD><TD>Parts</TD><TD>Category</TD><TD>OrderNo</TD><TD>Remark</TD></TR><TR><TD>CET0578</TD><TD>P05</TD><TD>Supply Issue</TD><TD>304</TD><TD>Result was came due to first preference category - Supply Issue</TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>forecast</TD><TD>304</TD><TD>Result was came due to second preference category - forecast</TD></TR><TR><TD>PCT0020</TD><TD>P56</TD><TD>Supply Issue</TD><TD>564</TD><TD>Result was came due to more than 1 Supply Issue on each orderline PCT0020,&nbsp; then I checked to Order No. 564 more than others ( I checked only "Supply Issue" not to forecast because Supply Issue is first preference</TD></TR><TR><TD>PCT0950</TD><TD>P05</TD><TD>forecast</TD><TD>938</TD><TD>Result was came due to more than 1 forecast on each orderline PCT0950,&nbsp; then I checked to Order No. 564 more than others in forecast.</TD></TR><TR><TD>PCT0389</TD><TD>P19</TD><TD>NA</TD><TD>938</TD><TD>Result was came due to third preference --&nbsp; Checked Supply Issue or Forecast are there or not, If not then nothing to check.</TD></TR><TR><TD>PCT0389</TD><TD>P31</TD><TD>Maintenance</TD><TD>938</TD><TD>&nbsp;</TD></TR><TR><TD>PCT0389</TD><TD>P22</TD><TD>Daily</TD><TD>370</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance to everyone for your input. I am waiting for the output result.</P><P>Please feel to reply if any doubts.</P><P>Kind Regards</P> Sat, 16 Nov 2024 17:59:20 GMT rakeshkumar1890 2024-11-16T17:59:20Z Logical Condition in Script https://community.qlik.com/t5/QlikView/Logical-Condition-in-Script/m-p/1751415#M453627 <P>Hello everyone,</P><P>Need your help to find out this logical condition on script.</P><P>Perference:</P><UL><LI>First Preference on Category : Supply Issue</LI><LI>Second Preference on Category : forecast</LI><LI>Third Preference on Category : Others categories</LI></UL><P>Check 1 :Per OrderLine, check category with given preference.&nbsp;</P><P>Check 2 :Per OrderLine, check category with given preference. If same category more than 1 then check into OrderNo counts. Maximum no. of counts should be output</P><P>We have the raw data like below:</P><TABLE><TBODY><TR><TD>OrderLine</TD><TD>Parts</TD><TD>Category</TD><TD>OrderNo</TD></TR><TR><TD>CET0578</TD><TD>P19</TD><TD>forecast</TD><TD>100</TD></TR><TR><TD><FONT color="#00FF00"><STRONG>CET0578</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>P05</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>Supply Issue</STRONG></FONT></TD><TD><FONT color="#00FF00"><STRONG>304</STRONG></FONT></TD></TR><TR><TD><FONT color="#FF6600"><STRONG>NIM0578</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>P24</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>forecast</STRONG></FONT></TD><TD><FONT color="#FF6600"><STRONG>304</STRONG></FONT></TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>invalid reason code</TD><TD>246</TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>supplier issue</TD><TD>304</TD></TR><TR><TD>PCT0020</TD><TD>P07</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD>PCT0020</TD><TD>P92</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD>PCT0020</TD><TD>P72</TD><TD>forecast</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P30</TD><TD>invalid reason code</TD><TD>564</TD></TR><TR><TD>PCT0020</TD><TD>P63</TD><TD>invalid reason code</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P14</TD><TD>supplier issue</TD><TD>564</TD></TR><TR><TD>PCT0020</TD><TD>P41</TD><TD>supplier issue</TD><TD>938</TD></TR><TR><TD>PCT0020</TD><TD>P10</TD><TD>Supply Issue</TD><TD>290</TD></TR><TR><TD>PCT0020</TD><TD>P90</TD><TD>Supply Issue</TD><TD>290</TD></TR><TR><TD><FONT color="#00FFFF"><STRONG>PCT0020</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>P56</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>Supply Issue</STRONG></FONT></TD><TD><FONT color="#00FFFF"><STRONG>564</STRONG></FONT></TD></TR><TR><TD>PCT0950</TD><TD>P02</TD><TD>forecast</TD><TD>200</TD></TR><TR><TD>PCT0950</TD><TD>P06</TD><TD>forecast</TD><TD>370</TD></TR><TR><TD><FONT color="#0000FF"><STRONG>PCT0950</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>P05</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>forecast</STRONG></FONT></TD><TD><FONT color="#0000FF"><STRONG>938</STRONG></FONT></TD></TR><TR><TD>PCT0950</TD><TD>P04</TD><TD>invalid reason code</TD><TD>938</TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P22</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>Daily</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>370</STRONG></FONT></TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P31</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>Maintenance</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>938</STRONG></FONT></TD></TR><TR><TD><FONT color="#99CC00"><STRONG>PCT0389</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>P19</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>NA</STRONG></FONT></TD><TD><FONT color="#99CC00"><STRONG>938</STRONG></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Output result:</P><TABLE><TBODY><TR><TD>OrderLine</TD><TD>Parts</TD><TD>Category</TD><TD>OrderNo</TD><TD>Remark</TD></TR><TR><TD>CET0578</TD><TD>P05</TD><TD>Supply Issue</TD><TD>304</TD><TD>Result was came due to first preference category - Supply Issue</TD></TR><TR><TD>NIM0578</TD><TD>P24</TD><TD>forecast</TD><TD>304</TD><TD>Result was came due to second preference category - forecast</TD></TR><TR><TD>PCT0020</TD><TD>P56</TD><TD>Supply Issue</TD><TD>564</TD><TD>Result was came due to more than 1 Supply Issue on each orderline PCT0020,&nbsp; then I checked to Order No. 564 more than others ( I checked only "Supply Issue" not to forecast because Supply Issue is first preference</TD></TR><TR><TD>PCT0950</TD><TD>P05</TD><TD>forecast</TD><TD>938</TD><TD>Result was came due to more than 1 forecast on each orderline PCT0950,&nbsp; then I checked to Order No. 564 more than others in forecast.</TD></TR><TR><TD>PCT0389</TD><TD>P19</TD><TD>NA</TD><TD>938</TD><TD>Result was came due to third preference --&nbsp; Checked Supply Issue or Forecast are there or not, If not then nothing to check.</TD></TR><TR><TD>PCT0389</TD><TD>P31</TD><TD>Maintenance</TD><TD>938</TD><TD>&nbsp;</TD></TR><TR><TD>PCT0389</TD><TD>P22</TD><TD>Daily</TD><TD>370</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance to everyone for your input. I am waiting for the output result.</P><P>Please feel to reply if any doubts.</P><P>Kind Regards</P> Sat, 16 Nov 2024 17:59:20 GMT https://community.qlik.com/t5/QlikView/Logical-Condition-in-Script/m-p/1751415#M453627 rakeshkumar1890 2024-11-16T17:59:20Z