Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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 !!
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))
)
Hi Chatny,
Thanks for your reply,
I will try this approach and update you.