Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
ajinkyabhonsle
New Contributor II

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
h_prakash
Contributor

Re: Current year vs Previous year in qliksense

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