Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Current year vs Previous year in qliksense

Hi Guys,

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:CvP.JPG






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.

1 Reply

Hi der,

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.