topic Re: Date on year selection in QlikView

Date on year selection

Tue, 20 Nov 2012 06:41:45 GMT

Hello,

When Year is selected then, I want 1st date of April month in a text object.

eg.

2012 -> 01/04/2012

2011 -> 01/04/2011

Please reply.

Thanks

Anonymous — Tue, 20 Nov 2012 06:48:40 GMT

=if(Year>0, '01/04/' & Year)

If you only want a text object with the value, you can use the above expression.

Tue, 20 Nov 2012 06:58:55 GMT

Hai,

Please find the attachment ,May be this is what you need.

Thanks,

Rathish

jagan — Tue, 20 Nov 2012 07:01:43 GMT

Hi,

Try this

=MakeDate(Max(Year), 4, 1)

Hope this helps you.

Regards,

Jagan.

Tue, 20 Nov 2012 07:14:38 GMT

use the makedate()

makedate(year(today()),month(today()))

Tue, 20 Nov 2012 07:24:00 GMT

Thanks

Wed, 21 Nov 2012 08:51:46 GMT

Thank You Guys..........:)