topic Issue with Date Fields in QlikView

Issue with Date Fields

Tue, 17 May 2011 19:04:20 GMT

Hello,

I am used to having tables which contain a date field that I can convert to month or year by using YearStart(Date) or MonthStart(Date). I now have a month field (1-12) and a Year Field (YYYY). I would like to add a rolling month fields that combines the month and year. Here is what I have given a shot with no luck.

Date(Month Feild & '/' & Year Field ,'MM/YY') as RollingMonth. ;

This script runs with no errors but does not produce the fields that I intended.

Any Help would be appreciated.

Thanks,
Jeff

Issue with Date Fields

spividori — Tue, 17 May 2011 19:14:03 GMT

Hi.

Try the following:

date(monthstart([Date]),'MMM YY') as RollingMonth.

Regards.

Issue with Date Fields

Tue, 17 May 2011 19:17:48 GMT

Hi Sandro,

Thanks for the quick response. My issue is that I do not have a full date feilds (mm/dd/yy) I only have a month field and a Year field. Can a make a rolling month by combining and using the date function?

Thanks Again,

Jeff

Issue with Date Fields

prieper — Tue, 17 May 2011 19:18:11 GMT

You may also use the internal function MONTHNAME(YourDate).

Peter

Issue with Date Fields

erichshiino — Tue, 17 May 2011 19:19:27 GMT

you can use makedate( YearField, MonthField)

I guess that if you want to use date, it`s going to be

Date#(Month Feild & '/' & Year Field ,'MM/YY')

Date(Month Feild & '/' & Year Field ,'MM/YYYY')

Hope it helps,

Erich

Issue with Date Fields

spividori — Tue, 17 May 2011 19:52:36 GMT

Another option could be:

date(monthstart(date('01.'&[Month Feild]&'.'&[Year Field])),'MMM YY') as RollingMonth

Regards.