topic Re: Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID in QlikView

topic Re: Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggregation-Function-to-get-Max-Datetime-Sales/m-p/1219975#M847984 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Try not to create multiple threads... look at my response here:</P><P style="font-size: 13.3333px;"><A href="https://community.qlik.com/thread/253546">Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID</A></P></BODY></HTML> Thu, 16 Mar 2017 09:42:18 GMT sunny_talwar 2017-03-16T09:42:18Z Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggregation-Function-to-get-Max-Datetime-Sales/m-p/1219974#M847983 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am Trying to get set analysis with Aggregation function , but its not happening  kindly help me to resolve this.</P><P>I Created Sample Excel Input data as well Out what i needed.</P><P></P><P> <STRONG>INPUT DATA :</STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" width="498"><TBODY><TR><TD height="20" width="105">BusinessID</TD><TD class="xl63" width="81">TransDate</TD><TD class="xl64" width="173">TransDateTime</TD><TD width="139">Sales Value</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">04-10-2016</TD><TD align="right" class="xl64">04-10-16 2:57:47 PM</TD><TD align="right">26.8</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">05-10-2016</TD><TD align="right" class="xl64">05-10-16 5:03:58 PM</TD><TD align="right">35.8</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">06-10-2016</TD><TD align="right" class="xl64">06-10-16 12:35:11 PM</TD><TD align="right">1585.8</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">07-10-2016</TD><TD align="right" class="xl64">07-10-16 6:50:11 PM</TD><TD align="right">1760.3</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">08-10-2016</TD><TD align="right" class="xl64">08-10-16 5:59:00 PM</TD><TD align="right">2.3</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">10-10-2016</TD><TD align="right" class="xl64">10-10-16 4:48:59 PM</TD><TD align="right">403.8</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">12-10-2016</TD><TD align="right" class="xl64">12-10-16 2:03:04 PM</TD><TD align="right">403.8</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">14-10-2016</TD><TD align="right" class="xl64">14-10-16 1:08:43 PM</TD><TD align="right">76.3</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">21-10-2016</TD><TD align="right" class="xl64">21-10-16 8:57:59 PM</TD><TD align="right">66.3</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl63">26-10-2016</TD><TD align="right" class="xl64">26-10-16 8:30:13 PM</TD><TD align="right">358.8</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">05-10-2016</TD><TD align="right" class="xl64">05-10-16 10:27:49 PM</TD><TD align="right">7357.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">06-10-2016</TD><TD align="right" class="xl64">06-10-16 1:06:33 PM</TD><TD align="right">2984.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">07-10-2016</TD><TD align="right" class="xl64">07-10-16 12:29:06 PM</TD><TD align="right">2931.25</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">10-10-2016</TD><TD align="right" class="xl64">10-10-16 11:18:15 AM</TD><TD align="right">2984.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">13-10-2016</TD><TD align="right" class="xl64">13-10-16 12:45:34 PM</TD><TD align="right">1946.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">15-10-2016</TD><TD align="right" class="xl64">15-10-16 5:55:00 PM</TD><TD align="right">16513.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">18-10-2016</TD><TD align="right" class="xl64">18-10-16 3:51:46 PM</TD><TD align="right">9262.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">19-10-2016</TD><TD align="right" class="xl64">19-10-16 5:04:12 PM</TD><TD align="right">68371.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">20-10-2016</TD><TD align="right" class="xl64">20-10-16 11:25:07 AM</TD><TD align="right">63351.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">23-10-2016</TD><TD align="right" class="xl64">23-10-16 11:46:45 PM</TD><TD align="right">58137.6</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">24-10-2016</TD><TD align="right" class="xl64">24-10-16 9:25:30 PM</TD><TD align="right">57143.04</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl63">30-10-2016</TD><TD align="right" class="xl64">30-10-16 6:24:23 PM</TD><TD align="right">52123.04</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">04-10-2016</TD><TD align="right" class="xl64">04-10-16 6:15:31 PM</TD><TD align="right">32.18</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">14-10-2016</TD><TD align="right" class="xl64">14-10-16 5:38:32 PM</TD><TD align="right">16532.18</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">15-10-2016</TD><TD align="right" class="xl64">15-10-16 4:10:14 PM</TD><TD align="right">7589.68</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">17-10-2016</TD><TD align="right" class="xl64">17-10-16 4:59:31 PM</TD><TD align="right">31.68</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">18-10-2016</TD><TD align="right" class="xl64">18-10-16 7:00:24 PM</TD><TD align="right">6382.28</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">19-10-2016</TD><TD align="right" class="xl64">19-10-16 5:41:49 PM</TD><TD align="right">651.28</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">21-10-2016</TD><TD align="right" class="xl64">21-10-16 5:10:09 PM</TD><TD align="right">1605.78</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">22-10-2016</TD><TD align="right" class="xl64">22-10-16 4:56:20 PM</TD><TD align="right">1217.28</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">23-10-2016</TD><TD align="right" class="xl64">23-10-16 6:54:04 PM</TD><TD align="right">589.28</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">24-10-2016</TD><TD align="right" class="xl64">24-10-16 6:13:04 PM</TD><TD align="right">10907.68</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">25-10-2016</TD><TD align="right" class="xl64">25-10-16 5:13:57 PM</TD><TD align="right">780.28</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl63">30-10-2016</TD><TD align="right" class="xl64">30-10-16 12:40:02 PM</TD><TD align="right">21.18</TD></TR></TBODY></TABLE><P>FIRST OUTPUT: if Cust not Selected any Date it need to Show max Datetime Sales value based on Business ID.</P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="362"><TBODY><TR><TD height="20" width="74">BusinessID</TD><TD class="xl65" width="73">TransDate</TD><TD class="xl66" width="137">TransDateTime</TD><TD width="78">Sales Value</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl65">26-10-2016</TD><TD align="right" class="xl66">26-10-16 8:30:13 PM</TD><TD align="right">358.8</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl65">24-10-2016</TD><TD align="right" class="xl66">24-10-16 9:25:30 PM</TD><TD align="right">57143.04</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl65">30-10-2016</TD><TD align="right" class="xl66">30-10-16 12:40:02 PM</TD><TD align="right"><P>21.18</P><P></P></TD></TR></TBODY></TABLE><P></P><P></P><P>SECOND OUTPUT : IF Cust selected Say 25 Oct 2016. So Max Datetime Sales Value Till 25 Oct 2016.</P><P></P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="355"><TBODY><TR><TD height="20" width="74">BusinessID</TD><TD class="xl65" width="73">TransDate</TD><TD class="xl66" width="130">TransDateTime</TD><TD width="78">Sales Value</TD></TR><TR><TD align="right" height="20">2146</TD><TD align="right" class="xl65">21-10-2016</TD><TD align="right" class="xl66">21-10-16 8:57:59 PM</TD><TD align="right">66.3</TD></TR><TR><TD align="right" height="20">2147</TD><TD align="right" class="xl65">24-10-2016</TD><TD align="right" class="xl66">24-10-16 9:25:30 PM</TD><TD align="right">57143.04</TD></TR><TR><TD align="right" height="20">2179</TD><TD align="right" class="xl65">25-10-2016</TD><TD align="right" class="xl66">25-10-16 5:13:57 PM</TD><TD align="right">780.28</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggregation-Function-to-get-Max-Datetime-Sales/m-p/1219974#M847983 brijeshvma 2020-11-25T16:16:04Z Re: Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggregation-Function-to-get-Max-Datetime-Sales/m-p/1219975#M847984 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Try not to create multiple threads... look at my response here:</P><P style="font-size: 13.3333px;"><A href="https://community.qlik.com/thread/253546">Set Analysis with Aggregation Function to get Max Datetime Sales based on Busines ID</A></P></BODY></HTML> Thu, 16 Mar 2017 09:42:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Aggregation-Function-to-get-Max-Datetime-Sales/m-p/1219975#M847984 sunny_talwar 2017-03-16T09:42:18Z