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.

1 Solution

Accepted Solutions
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!

View solution in original post

20 Replies
Not applicable


Hi,

Correct but mostly starts from Jan to Dec only.

Some users follow the fiscal calender so it will start from Apr to Mar.

alkesh_sharma
Creator III
Creator III
Author

I know, but the situation is that, users are across world and follow different financial years.

So I need a scenario where user can select what calender he wants to follow

Kushal_Chawda

Please see the below link.

http://community.qlik.com/docs/DOC-7094

If your Financial Month starts from Feb , then change Variable vFiscalYearStartMonth = 2;

Not applicable

Hi Alkesh,

You can create mapping table like Country / Region / Month Wise financial year and link it with your master calendar and let user to select the Country / Region / Month.

Regards

Nandkishor Pandirkar

alkesh_sharma
Creator III
Creator III
Author

But for that I guess I need to create 12 different master calenders. Please correct me if I am wrong.

alkesh_sharma
Creator III
Creator III
Author

This is scripting part you are telling me. User cannot do scripting.

He will just select a month and all the calendar will change in itself. Something which  UI driven

Not applicable

Hi,

You don't require twelve master calendar,You require one mapping table with above different combination

eg for India

pic1.gif

jagan
Luminary Alumni
Luminary Alumni

Hi,

To handle this front end it is very difficult to handle, can you come up with a sample?

Regards,

Jagan.

alkesh_sharma
Creator III
Creator III
Author

Hello Nandkishor

I still didn't get the logic as how this will be achieved.

Can you share me a test QVW with your logic.?