Discussion board where members can get started with Qlik Sense.
I want to create a table in Qliksense and compare previous fiscal year vs current fiscal year. I have three fields -
(1) Fiscal_Year - FY19, FY18, FY17
(2) Fiscal_Quarter, - 18Q1, 18Q2, 18Q3 etc...
(3) Year_Month - 2018 -01, 2018- 02, 2018 -03 etc....
I would want to create a table something like this:
I would want the user to select the filters eg: Fiscal Year FY19 and the table should change to show current year = FY19 data and Previous Year = FY18 data.
What formual should I use in the measures to get this flexibility.
Thanks for your help.
Assuming ur current year set Analysis expression like this,
For previous year it would be like
If it is not working Please share your Current Year Set Analysis expression.