topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/914853#M983298 <HTML><HEAD></HEAD><BODY><P>If you want the max contract_start_date per product I'd create a flag field in the script:</P><P></P><P>JOIN (SupplierOrders)</P><P></P><P>LOAD product_key, max(contract_start_date) as contract_start_date, 1 as IsMaxContractStartDate</P><P>Resident SupplierOrders</P><P>Group By product_key;</P><P></P><P>You can then use that new field to select the records you need. Change your expressions to select them: sum({&lt;<SPAN style="font-size: 13.3333330154419px;">IsMaxContractStartDate={1}</SPAN>&gt;}[Order Qty])</P></BODY></HTML> Fri, 07 Aug 2015 09:26:45 GMT Gysbert_Wassenaar 2015-08-07T09:26:45Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/914852#M983297 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">I want to fetch the product details which is having max(contract_start_date)</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Please find the sample model attached</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Result :</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Mark in yellow</SPAN></P><P></P><P><IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95320_sample.PNG" style="height: 60px; width: 620px;" /></P></BODY></HTML> Fri, 07 Aug 2015 08:21:42 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/914852#M983297 suvechha_b 2015-08-07T08:21:42Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/914853#M983298 <HTML><HEAD></HEAD><BODY><P>If you want the max contract_start_date per product I'd create a flag field in the script:</P><P></P><P>JOIN (SupplierOrders)</P><P></P><P>LOAD product_key, max(contract_start_date) as contract_start_date, 1 as IsMaxContractStartDate</P><P>Resident SupplierOrders</P><P>Group By product_key;</P><P></P><P>You can then use that new field to select the records you need. Change your expressions to select them: sum({&lt;<SPAN style="font-size: 13.3333330154419px;">IsMaxContractStartDate={1}</SPAN>&gt;}[Order Qty])</P></BODY></HTML> Fri, 07 Aug 2015 09:26:45 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/914853#M983298 Gysbert_Wassenaar 2015-08-07T09:26:45Z