Show Dimension as Fiscal Year

[xding]

Hi,

I'm having an issue that needs to show the sequence of Month in chart as our fiscal year. Oct is the first month of our FY, here the correct consequence is to show the data as (Oct, Nov, Dec, Jan, Feb...) as dimension. How I can make that? Would you please help to take a look?

Thanks a lot.

[vikasmahajan]

create master calendar refer following script :

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

use monthname as a dimension for show months in chart

Thanks

Vikas

[xding]

Hi Vikas,

Thanks for help.

I can't see the below link in your pointed post. 

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

in addition, as script, could you please share [lib://3_Qvds/FactY2Data.qvd] (qvd) and [lib://3_Qvds/FactY2Data.qvd](qvd) with me to try to use?

Thank you.

[vikasmahajan]

you need  to follow

1. Please find attached master calendar script which you can use in your app using min & max date.

2. you common columns you need to create link table please refer following link for more in details:

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Hope this help you.

Vikas