topic Re: Get last date for which has a value in QlikView

Get last date for which has a value

Anonymous — Wed, 13 Feb 2013 08:33:00 GMT

Hi,

I have the following table:

Date	Production (meters)
01/02/2013	108
02/02/2013	502
03/02/2013	300
04/02/2013	0
05/02/2013	0

I want to get the last date which has got a Production value (so it will be 03/02/2013 because the dates thereafter has not values). The date must be able to show in a text box.

How can I do it using a formula/expression?

Thank you in advance

Re: Get last date for which has a value

vivientexier — Wed, 13 Feb 2013 08:43:09 GMT

Add a flag in your script (1 when Production >0),

Then your expression will be easy Max({< Flag_production_value = {1} >} Date)

Re: Get last date for which has a value

jonathandienst — Wed, 13 Feb 2013 08:54:12 GMT

This should do it

=Date(Max(If(Production <> 0, Date)))

Hope that helps

Jonathan

Re: Get last date for which has a value

Wed, 13 Feb 2013 08:56:53 GMT

Hi Hennie,

You should solve with this exèression:

Max( {<Production={">0"}>} Date)

Hope it helps

Giampiero

Re: Get last date for which has a value

manideep78 — Wed, 13 Feb 2013 09:03:45 GMT

Hi,

This should work, try this

=Date(Max({<Production={"<>0"}>}Date))

Re: Get last date for which has a value

sushil353 — Wed, 13 Feb 2013 09:08:04 GMT

try this

=Date(max({<Production ={"<>0"}>} Date_t))

find the sample application

HTH

Sushil

Re: Get last date for which has a value

Anonymous — Wed, 13 Feb 2013 09:14:26 GMT

Hi ,

do the below

1.In script load date as Num(Date) as Date

2.use set ananlysis in text object =sum({<Date={$(=max(Date))}>}value)

Regards,

Anant Dubey

Re: Get last date for which has a value

Anonymous — Wed, 13 Feb 2013 09:23:32 GMT

Thank you everyone! I've now got a few expressions from which I can pick and choose!