Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Year over year comparison

Hi ,

I would like to create a chart that shows sales dynamic year over year within year dimension and month dimension like below.


But what i made shows like below , i cannot get the correct value in col Lastyear_Sales on Mar 2019,  and it will be affected by the filter what i selected, it's not what i expected.


The attached is qvf.  Does anyone have any suggestion for how to get that done?

Thanks in advance!

1 Reply

The problem is that you can't (easily) show a result for 2019 that's calculated from values from 2018.

You can solve this with an AsOf table. See this blog post for more information: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

talk is cheap, supply exceeds demand