Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
=Max(BillValue)
=Max(DiscountCoupon)
=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.