topic How to write the expression ? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1267792#M854452 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>Please anybody can help me in writing the expression&nbsp; to get the Value calculated.</P><P></P><P><IMG __jive_id="152998" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152998_Capture.PNG" style="height: 261px; width: 620px;" /></P><P></P><P>According to my requirements :</P><P>1. Cost Price for this product and selected Fiscal year and Fiscal Month will be 238.85. It will change when the filter selection is done.- the cost price will reflect the (cost price) for the max(cost_price_date) for order type 'Closing Balance'</P><P></P><P>2. The Value will be calculated : Qty * <SPAN style="font-size: 13.3333px;">(cost price) for the max(cost_price_date)</SPAN> i.e 238.85 . This will work only when order type ='Closing Balance'</P><P></P><P>Sample Model attached.</P><P></P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT suvechha_b 2020-11-25T16:16:04Z How to write the expression ? https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1267792#M854452 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>Please anybody can help me in writing the expression&nbsp; to get the Value calculated.</P><P></P><P><IMG __jive_id="152998" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152998_Capture.PNG" style="height: 261px; width: 620px;" /></P><P></P><P>According to my requirements :</P><P>1. Cost Price for this product and selected Fiscal year and Fiscal Month will be 238.85. It will change when the filter selection is done.- the cost price will reflect the (cost price) for the max(cost_price_date) for order type 'Closing Balance'</P><P></P><P>2. The Value will be calculated : Qty * <SPAN style="font-size: 13.3333px;">(cost price) for the max(cost_price_date)</SPAN> i.e 238.85 . This will work only when order type ='Closing Balance'</P><P></P><P>Sample Model attached.</P><P></P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/1267792#M854452 suvechha_b 2020-11-25T16:16:04Z