topic Date function in QlikView

Date function

Fri, 05 Sep 2014 11:04:32 GMT

Hi Friends

How do I get fiscal Month name like from Oct 2013, Nov 2013.... Sep 2014,

If I use MonthName(InvoiceDate,-3) it shows data of April 2014.

could you please how to do this.

Anonymous — Fri, 05 Sep 2014 11:07:26 GMT

try

monthname(addmonths(InvoiceDate,-3))

amit_saini — Fri, 05 Sep 2014 11:10:16 GMT

Chriss,

Try this:

dual(date(Datefield, 'MMM YY'), year(Datefield)*100+month(Datefield)) as MonthYear,

Thanks,
AS

Fri, 05 Sep 2014 11:14:02 GMT

This should work.

MarcoWedel — Fri, 05 Sep 2014 11:19:37 GMT

please specify your question.

MonthName(InvoiceDate,-3)

delivering 'Apr 2014' would mean InvoiceDate is any date from July 2014 shifted by -3 months to April.

If you mean, you would like to get 'April 2014' instead of 'Apr 2014', then

Date(MonthName(InvoiceDate,-3), 'MMMM YYYY')

is what you are looking for.

hope this helps

regards

Marco

MayilVahanan — Fri, 05 Sep 2014 11:22:14 GMT

Please refer