Does anyone know how i can work this out...If I am woking with products is there a way I can indicate on QV when the last sale of a product took place??
Yes, you can create one listbox for product and another list box for 'sale date', then sort the sale date listbox in descending order.Now, when you select a product in the product listbox, the first line in the sale date list box will give you last sale of that product.
It depends on the object you are working with, but the following expression
FirstSortedValue(Product, -Date)
Should return the correct Product value for the last Date. You can use this function in both the script (you will need to group by) or in a chart (it will depend on your dimensions).
That is working but my date key is my dimention it gives the correct awnser that i what but it gives all the dates that the product was sold at...But i only want the last date that the product was sold at like product 1 was sold at 2011/10/02, product 2 was sold at 2009/02/17 that expression you gave me works but returns all dates that, that 1 product was sold at...
.png "Miguel_Angel_Baeyens"){kind=avatar}
