Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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