NEW YEAR REQUIREMENT

[manu1512]

Hi all,

I have a requirement where we want to have year from september to august.Can any one tell us how to do?

[YoussefBelloum]

Hi,

you are talking about reload (script) ? or on some analysis (expressions) ??

[Anil_Babu_Samineni]

What year is that? Perhaps this?

Load *, If(Year = 2017 and (Month >= 'september' and Month <= 'august'), 1,0) as Flag;

Load Year(Date) as Year,

         Date(Month(Date), 'MMMM') as Month

From Table;

[manu1512]

from script yusuf

[manu1512]

from every year from 1986 to 2050

[m_woolf]

Qlik Design Blog : Fiscal Year | Qlik Community

[Anil_Babu_Samineni]

You can use where condition to restrict the data like my month condition?

[Siva_Sankar]

Fiscal and Standard Calendar generation