Month over month

[Ayush_123]

Hi team,

I am calculating month over month in a table. While using Above function I am getting null for Jan21 but data for Dec20 (which is prev month) is available. Please tell me the correct way to do it.

Many thanks!

[Digvijay_Singh]

Try 'Total' in your expression, looks like for each year above value gets reset. Check here for more details - 

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In...