topic Re: Calendar Field in QlikView

Calendar Field

Tue, 05 Jan 2016 10:33:21 GMT

Hi All

I have a "Date" field and would like to use to create a BudgetMonth Field based on two dates.

The condition is that the budget months starts on the 26th of every months and ends on the 25th. I would like to create a Field that can give me a result like this: from 26 December to 25 January "Dec - Jan", from 26 January to 25 February "Jan - Feb"

How can I write this expression?

Re: Calendar Field

sunny_talwar — Tue, 05 Jan 2016 10:39:52 GMT

This?

Script:

Table:

LOAD *,

If(Day(Date) < 26, Month(Date) & ' - ' & Month(AddMonths(Date, -1)), Month(AddMonths(Date, 1)) & ' - ' & Month(Date)) as BudgetMonth;

LOAD Date(MakeDate(2014, 12, 31) + RecNo()) as Date

AutoGenerate 730;

Re: Calendar Field

Chanty4u — Tue, 05 Jan 2016 10:40:32 GMT

hi,

https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

chk abve link

Re: Calendar Field

Tue, 05 Jan 2016 10:44:15 GMT

Thanks ...my expression was slightly different hence wit was not working