Using fiscal year instead of calendar year in Qliksense

[#1]

Hi,

I did a lot of searching. But all the solutions are for Qlikview. Need to understand how I can create all my graphs/charts for yearly/quarterly/monthly/weekly sales as per a fiscal calendar and not the calendar field in QlikSense. My odbc db has a column called bdate which stores the date.

Thanks,

Saurabh Agrawal

[Gysbert_Wassenaar · Accepted solution]

You can use the same script code for Qlik Sense as you can find for Qlikview. The only differences are the connections to files and databases. The script from this blog post will work fine to generate a fiscal calendar in Qlik Sense: Fiscal Year‌. You can find a more comprehensive calendar script in the comments: https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year#comment-18082

[#3]

Hello Gysbert,

This looks good. Thanks a lot. But I am not able to arrange the months as per the fiscal year. How do I sort them?

Regards,

Saurabh Agrawal

[Raju_6952]

in the sort by expression use max(date) then it will sort accoding to the custom month and year sorting