
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month over month comparison
Hello Everyone,
I am having some issues getting the Month over Month. I know my issue is with the previous month calculation. I created variables for current and previous month. The problem is when I select a month my MoM returns a zero. I added images to show what happens when I make a selection.
Current Month
Sum({$<MonthYear ={'$(=vMaxYearMonth)'}>} Provider )
Previous Month
Sum({$<MonthYear={"$(=vPreviousMaxMonth)"}>}Provider)
Provider MoM
( Sum({$<MonthYear ={'$(=vMaxYearMonth)'}>} Provider )
-
Sum({$<MonthYear={"$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YY'))"}>}Provider)
)
/
Sum({$<MonthYear={"$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YY'))"}>}Provider)
- Tags:
- qlik sense
- qlik view
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I meant excluding it like this:
Current Month
Sum({$<MonthYear ={'$(=vMaxYearMonth)'}, [createdDate.autoCalendar.YearMonth]=>} Provider )
Previous Month
Sum({$<MonthYear={"$(=vPreviousMaxMonth)"}, [createdDate.autoCalendar.YearMonth]=>}Provider)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Since you are selecting on field createdDate.autoCalendar.YearMonth, try excluding it from the set analysis.
Or use the MonthYear field for the Dimension/Filter

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Quy_Nguyen ,
I tried using it in my filter but I'm only seeing the current month not the previous month when I make a selection

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I meant excluding it like this:
Current Month
Sum({$<MonthYear ={'$(=vMaxYearMonth)'}, [createdDate.autoCalendar.YearMonth]=>} Provider )
Previous Month
Sum({$<MonthYear={"$(=vPreviousMaxMonth)"}, [createdDate.autoCalendar.YearMonth]=>}Provider)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Quy_Nguyen Thank you!!! It worked
