I want to know Last order value by using formula

[vja]

Hi Qlik Team,

Please let me know how use formula for below data points

Data Points

1) Last order Bill value 
2) Last order discount coupon used 
3) Last order name of Product Name.

[jcmachado]

In Qlik , you can use the following formulas to extract the last order Bill value, last order discount coupon used, and last order name of Product Name:

1. Last order Bill value: You can use the Max() function to find the maximum Bill value in your data.

=Max(BillValue)

2. Last order discount coupon used: You can use the Max() function to find the discount coupon used in the last order.

=Max(DiscountCoupon)

3. Last order name of Product Name: You can use the FirstSortedValue() function to find the name of the product in the last order.

=FirstSortedValue(ProductName, -Date)

Where "BillValue" is the field name of the Bill value, "DiscountCoupon" is the field name of the discount coupon used, "ProductName" is the field name of the product name, and "Date" is the field name of the date of the order.

Please note that this is just an example, you might want to adjust the formula according to your data and needs.