Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Gopi_E
Creator II
Creator II

MOM Trend values by month and Year in Pivot table

Hi Qlikers,

I have a scenario where i need to get MOM value by month and year in Pivot table.

My current table structure is like below

Expression: (Sum(Sales)-Before(Sum(Sales))/Before(Sum(Sales))

Gopi_E_1-1681905774358.png

Current Issue:
Not getting MOM value for Jan starting month of the year

For Jan - 2023 the value should be consider for -  (Jan-2023-Dec-2022)/Dec-2022.

Could you please guide me to get Jan mom value for this view

Thanks in advance !!

@hic @sunny_talwar  

Labels (7)
2 Replies
Chanty4u
MVP
MVP

Hi try this 

 

If(Month(Date) = 1, 

   (Sum(Sales)-Before(Sum(Sales), 12))/Before(Sum(Sales), 12),

   (Sum(Sales)-Before(Sum(Sales)))/Before(Sum(Sales))

)

 

Gopi_E
Creator II
Creator II
Author

Hi Chatny,

Thanks for your reply,

I will try this approach and update you.