Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alkesh_sharma
Creator III
Creator III

Financial Year and Financial Year to be defined by User..

Hi All,

Can my Financial Year and  Financial Quarter be defined by user.

For eg: if user says his first Month is Feb, than financial year starts from 1st feb to 31st Jan and Q1 would be feb- march - apr..

Something like this...

Help guys.. its urgent.

20 Replies
alkesh_sharma
Creator III
Creator III
Author

Not on the UI, but may be something I can do on the scripting....

alkesh_sharma
Creator III
Creator III
Author

Ashfaq Mohammed, Ruben Marin

Guys Please Help

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this.

Regards

ASHFAQ

rubenmarin

Sorry, today I don't have time to make tests, probably I'll try to concatenate different master calendars, one for each fiscal-month start, adding a field to filter the fiscal-calendar in front-end with 'always one value selected'.

alkesh_sharma
Creator III
Creator III
Author

Hello Ashfaq,

With this I need to change the script in the background, to make the changes in the financial calender.

Can you help me creating Master calender for 12 different financial years and concatenating them year after the year.

I an trying by getting syntax error.

Can you help me out in creating in that.

alkesh_sharma
Creator III
Creator III
Author

Thanx Ruben,

I was trying the same approach, but couldn't get the syntaxes ryte.

rubenmarin

I don't have the time to debug today but following the file uploaded by ashfaq it will be something like the attachment. It will need a litle changes but it's a start.

Hope this helps!

ashfaq_haseeb
Champion III
Champion III

Hi,

Tell me start and end year

Rgards

ASHFAQ

Kushal_Chawda

Please see the attached file.

You can select the FiscalYear_Month_Selection and it will automatically select the Fiscal Year ,Month and Quarter

alkesh_sharma
Creator III
Creator III
Author

Thanx Ruben, Thanx a ton...