topic Re: How to use make date function??? in QlikView

How to use make date function???

Anonymous — Sat, 18 Oct 2014 10:41:24 GMT

I have a field called 'Paid in' which stores value 'September' in excel and now i am bringing that field into qlikview and I would like to use makedate function ,My previous developer used the function like this but

its not showing any result and I need to know what it is trying to do .

Date#(date(Makedate(num(Year),[GS3 Paid in],1))) as OBJ_GSoS_EndDate,

Can any one help me out this , How can I make it work.

Its a bit urgent pls

Regards,

Sharma.

Re: How to use make date function???

MarcoWedel — Sat, 18 Oct 2014 11:13:03 GMT

=Date#(Year&[GS3 Paid in],'YYYYMMMM') as OBJ_GSoS_EndDate,

supposed your Year is a 4 digit number.

hope this helps

regards

Marco

Re: How to use make date function???

Anonymous — Sat, 18 Oct 2014 11:41:49 GMT

Hi marco,

it is showing the error , saying that field not found <year>

How shall i do that .

Regards,

Sharma.

Re: How to use make date function???

MarcoWedel — Sat, 18 Oct 2014 12:59:00 GMT

your initial question suggests that there has been a Year-Field in your application.

Can you post a sample QVW to look into?

regards

Marco

Re: How to use make date function???

Anonymous — Sat, 18 Oct 2014 13:23:40 GMT

Hi marco ,I dont have a attach file option here , Any idea?

Re: Re: How to use make date function???

MarcoWedel — Sat, 18 Oct 2014 14:18:02 GMT

Hi,

in edit mode click on "Use advanced editor" and then "Attach":

hope this helps

regards

Marco

Re: Re: How to use make date function???

Anonymous — Sat, 18 Oct 2014 14:29:52 GMT

Hi Marco,
I cant see that option at my desktop like use advanced editor. why any idea?

Regards,

Sharma.

Re: How to use make date function???

MarcoWedel — Sat, 18 Oct 2014 14:53:35 GMT

No, none.

Should be there in edit mode.

Maybe the community administrators can help?

regards

Marco