MoM and YoY calculation in Stright Table

[anat]

Hi ,

i am having data like

MonthYear,Sales

Jan-2022,100

Feb-2022,150

Mar-2022,200

Jan-2023,250

Mar-2023,300

i need to calculate MoM & YoY in stright table as below

Month,Sales,Mom,YoY

Jan-2022,100,(100-0),(100-0)

Feb-2022,150,(150-100),(150-0)

Mar-2022,200,(200-150),(200-0)

Jan-2023,250,(250-0),(250-100)

Mar-2023,300,(300-250),(300-200)

MoM logic: current Month- Previous Month

YoY : Current Month Year - Last Year for same Month

[vikasmahajan]

Hi ,

Did you try this :

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245

[anat]

Thanks @vikasmahajan  for the prompt response, actually  i am looking for the solution at table level not in KPI 

[vikasmahajan]

Hi anant,

Sorry please refer following link where you can create a flags in calendar and use this flags in set analysis for YTD/MTD/QTD & MAT sales.

https://community.qlik.com/t5/Member-Articles/As-of-Table-with-YTD-MTD-QTD-amp-Calculation-of-Rollin...

Hope this will help you for YOY & MOM  rest all in feature like  YTD vs PYTD , MTD Vs PMTD etc.

Vikas