Discussion board where members can get started with Qlik Sense.
My requirement is to get MOM in Pivot table like below image.
2018-Apr MOM should be 2018-Apr vs 2018-mar (252-42=210)
2018-Mar MOM Should be 2018-mar Vs 2018-Feb(42-176 = - 134)
Please find below attachments for Solution
I used below as my sample data to create the Pivot table
MOM:Load * inline [Product,YearMonth,SalesA,2018-Jan,746A,2018-Feb,176A,2018-Mar,42A,2018-Apr,252B,2018-Jan,442B,2018-Feb,70B,2018-Mar,57B,2018-Apr,19C,2018-Jan,322C,2018-Feb,337C,2018-Mar,385C,2018-Apr,112D,2018-Jan,182D,2018-Feb,400D,2018-Mar,372D,2018-Apr,278];
1st Dimension as --> Product
2nd Dimension as --> MonthYear
1st Expression as --> =Sum(Sales) which is labeled as Sales
2nd Expression as --> =Sum(Sales)-above(Sales)
Hope this helps you
In my requirement Yearmonth is used as column.