topic Min date in Max year in QlikView

Min date in Max year

Anonymous — Thu, 15 Aug 2013 11:42:37 GMT

I sincerely do not want to use the makedate function because it has to be dynamic.So for instance this Year being '2013' and Min Date in this year is 1/1/13.

Thanks

Re: Min date in Max year

lironbaram — Thu, 15 Aug 2013 12:24:46 GMT

you cab use the function yearstart(max({1}date))

Re: Min date in Max year

swuehl — Thu, 15 Aug 2013 12:24:50 GMT

Hm, not sure what you want to achieve, maybe

=Date(Yearstart(today()))

Re: Min date in Max year

Gysbert_Wassenaar — Thu, 15 Aug 2013 12:24:57 GMT

Something like this maybe: min({<MyYearField={$(=max(MyYearField))}>}MyDateField)

Re: Min date in Max year

Anonymous — Thu, 15 Aug 2013 13:52:56 GMT

Thanks all

Kwame