topic Re: Max Date/Script in QlikView

Max Date/Script

Fri, 30 Aug 2013 11:15:39 GMT

Hi All,

Attached is an excel with the fields,

Date Field1 Field2

I want to get the maximum date for EACH MONTH where Field1 is not zero.

If you see the excel, i want

8/17/2013

and

9/13/2013

.I have more than 30 months in my data.Is it possible to get these max dates in a particular field in the script?Or any other solution will help.

Thanks and Regards,

Pavan

MayilVahanan — Fri, 30 Aug 2013 11:22:24 GMT

Try like this

If(Field1 <> Previous(Field1) and Field1 = 0, Previous(Date)) as Date

tresB — Fri, 30 Aug 2013 11:27:54 GMT

PFA