This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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