Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
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
Highlighted
Creator
Creator

Hi der,

Assuming ur current year set Analysis expression like this,

=Sum({<FY={'$(=Max(FY))'}>}Finance)

For previous year it would be like

Sum({<FY={'$(=Max(FY)-1)'}>}Finance)

If it is not working Please share your Current Year Set Analysis expression.

Thanks

Prakash