MoM line chart

[xding]

Hello Everyone,

I am having some issues getting the Month over Month.  I know my issue is with the previous month calculation. I don't know how to set expression to calculate MoM rate to show in line chart ,especially Sum view data for the previous month. I added images to show my data.

Would you please help with this? Thanks in advance.

[xding]

Hello Everyone,

I am having some issues getting the Month over Month.  I know my issue is with the previous month calculation. I don't know how to set expression to calculate MoM rate to show in line chart ,especially Sum view data for the previous month. I added images to show my data.

Would you please help with this? Thanks in advance.

[JHuis]

To clearify: you want to calculate the difference between the last and previous month?

[xding]

Hi , thanks for helping. Yes, I need to calculate sum view the different between the last and previous month.

[JHuis · Accepted solution]

Hi, 

you can add a different measure and use the modifiers and then 'Difference'

See this link:

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers.h...

[xding]

HiJHuis, as tried, it works. Thanks a lot for help.