Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

calendar year to financial year

hi am trying to change my calendar year to financial year,

and the logic for quarter field I have used is (it has format as q1-2013...…..)

Dual(Text('Q'&Num(Ceil(Num(Month(AddMonths($1,1-vFM)))/3))),Num(Ceil(NUM(Month(AddMonths($1,1-vFM))))/3,'00'))
&'-'& Dual(Text(Year($1)), num(YearStart($1),'00')) as Quarter,

 

but this code doesn't seems to be working ,can you please help,

2 Replies
Highlighted

Re: calendar year to financial year

What do you get and what are you hoping to get? Would you be able to share a sample and provide the output you expect from it?

Highlighted
Digital Support
Digital Support

Re: calendar year to financial year

Below is a Design Blog post that may be of some use to you:

Fiscal Year Design Blog post

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.