How to categorize 'Years' in Qlik sense according to Indian Tax norms?
I am using Qlik Sense Desktop and I am facing a peculiar problem. According to the Indian Tax system, a financial year is 1st April to 31st March. For example, financial year 2015-2016 would be from 1st April 2015 to 31st March 2016. Now in Qlik Sense, it considers 'Year' as calendar year i.e 1st Jan 2015 to 31st December 2015. This poses a problem for me because if I want to compare year-on-year sales, I want the year to be financial year as per Indian Tax norms and not calendar year. If it helps, I am using data from an excel sheet.