topic date in QlikView

date

Tue, 20 Nov 2012 05:45:29 GMT

I want date as 1/04/2012 if I select year 2012 or any year ...

means I want only first date of april month for that particular year

can any one help??

Re: date

Tue, 20 Nov 2012 05:48:46 GMT

Try This

if(year='max(year)',monthstart(monthname))

Re: date

Anonymous — Tue, 20 Nov 2012 05:51:22 GMT

hi Reshma,

U can use MonthStart () function

Eg: MonthStart(Monthname)

Hope it workz....

regards,

Vaibhav

Re: date

Tue, 20 Nov 2012 06:10:28 GMT

but I want that particular year also get change what I select

Re: date

Tue, 20 Nov 2012 06:12:47 GMT

Can you share your test app with me

Re: date

Tue, 20 Nov 2012 06:17:43 GMT

if you use that above expression.......what output is it shows?

Re: date

Tue, 20 Nov 2012 06:21:12 GMT

use the makedate()

for exm

makedate(2012,4)---

it gives 4/1/2012

Re: date

Tue, 20 Nov 2012 06:26:29 GMT

see the below expr

i use this expr in calculated dimension

=makedate(year(PERIOD_START_DATE),month(today()))

it works for me

try this expr.

Re: date

Tue, 20 Nov 2012 06:41:40 GMT

I did this to ur expression and I am now getting the proper answer for that particular Year

=date(date#(if(Year=max(Year),'01/04/' & Year)),'MM,DD,YYYY')

Re: date

jagan — Tue, 20 Nov 2012 07:04:49 GMT

Hi,

Try this, this is the simple way

=Date(MakeDate(Max(Year), 4, 1), 'DD/MM/YYYY')

Regards,

Jagan.

Re: date

Tue, 20 Nov 2012 07:13:49 GMT

Dear Reshma,

pls Find The Attachment

Regards

Chandu