https://community.qlik.com/t5/QlikView/Script-to-Prefix-Max-Value-and-Data/m-p/1574299#M456795 <P>Hello all,</P><P>I would like to ask if below is possible? I would like to find out customer's favourite category by date for each customer in <STRONG>Script level</STRONG> but I'm unable to figure out. Below is my dataset.</P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Accessories</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Accessories</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Accessories</TD></TR></TBODY></TABLE><P><SPAN><BR />Expected Result:</SPAN></P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance!</P> Sat, 16 Nov 2024 03:43:33 GMT jerfwork 2024-11-16T03:43:33Z https://community.qlik.com/t5/QlikView/Script-to-Prefix-Max-Value-and-Data/m-p/1574299#M456795 <P>Hello all,</P><P>I would like to ask if below is possible? I would like to find out customer's favourite category by date for each customer in <STRONG>Script level</STRONG> but I'm unable to figure out. Below is my dataset.</P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Accessories</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Accessories</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Accessories</TD></TR></TBODY></TABLE><P><SPAN><BR />Expected Result:</SPAN></P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerA</TD><TD>30/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerA</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR><TR><TD>CustomerB</TD><TD>29/04/2017</TD><TD>Shoes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance!</P> Sat, 16 Nov 2024 03:43:33 GMT https://community.qlik.com/t5/QlikView/Script-to-Prefix-Max-Value-and-Data/m-p/1574299#M456795 jerfwork 2024-11-16T03:43:33Z https://community.qlik.com/t5/QlikView/Script-to-Prefix-Max-Value-and-Data/m-p/1574307#M456796 <P>I managed to get the highest info now by using FirstSortedValue and COUNT, but if the dataset is showing as below. The result will be blank. Is that a possibility auto populate a random value from Category if it is blank?</P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerB</TD><TD>28/04/2017</TD><TD>Bags</TD></TR><TR><TD>CustomerB</TD><TD>28/04/2017</TD><TD>Accessories</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result:</P><TABLE><TBODY><TR><TD>CUSTOMER_NO</TD><TD>DATE_OF_PURCHASE</TD><TD>DIMENSION</TD></TR><TR><TD>CustomerB</TD><TD>28/04/2017</TD><TD>Bags</TD></TR></TBODY></TABLE> Mon, 29 Apr 2019 07:57:03 GMT https://community.qlik.com/t5/QlikView/Script-to-Prefix-Max-Value-and-Data/m-p/1574307#M456796 jerfwork 2019-04-29T07:57:03Z