topic Dates in QlikView

Dates

stevietm — Tue, 21 Jun 2011 11:24:02 GMT

Hi All

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??

Kind Regards

Re: Dates

Tue, 21 Jun 2011 11:31:42 GMT

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.

Arun

Re: Dates

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 11:33:35 GMT

Hello,

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).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Dates

stevietm — Wed, 22 Jun 2011 13:25:19 GMT

Hey Miguel

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...

Regards Stevie

Re: Dates

Miguel_Angel_Baeyens — Sat, 25 Jun 2011 07:53:30 GMT

Hello Stevie,

Take a look at this post. Not knowing your data model better, it's another approach I can think of.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica