Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nicouek
Contributor III
Contributor III

Testing my Fiscal Calendar

Good morning or evening all

I was wondering if someone can assist me with the process on how to effectively test my Fiscal Calendar script?

I wrote a script to set my fiscal year beginning on October 1st and ending September 30th for a project I am working on. However when I try to test the calendar by bring in the YearField and MonthField into a straight table, the months still line up from Jan to Dec. Is that expected?  I am doing something wrong? How do I conduct this test effectively.

Thank you for you time and consideration

Sincerely,

1 Solution

Accepted Solutions
vikasmahajan

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

your fiscal year will start  from oct  like Set vFM = 10;                                                          // First month of fiscal year

also refer this

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

take master calender script from my post.

https://community.qlik.com/t5/App-Development/Master-Calender/m-p/1883271#M72729

hope this help you

Vikas

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

3 Replies
vikasmahajan

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

your fiscal year will start  from oct  like Set vFM = 10;                                                          // First month of fiscal year

also refer this

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

take master calender script from my post.

https://community.qlik.com/t5/App-Development/Master-Calender/m-p/1883271#M72729

hope this help you

Vikas

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
nicouek
Contributor III
Contributor III
Author

Hello Vikasmahajan

Thank you for the assist, your response with the links helped thank you. Really appreciate it

Sincerely,

vikasmahajan

I am glad it works for you !

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.