Discussion board where members can get started with Qlik Sense.
Help to me find MOM Dynamically as per below table, condition is in last column
Go to Solution.
If the fields are sorted properly on table, same expression will work perfectly.
But if you make it work on unsorted table, you should use aggr function with structure parameters to sort fields properly in background for calculations.
sum(aggr(sum(Revenue)-alt(above(sum(Revenue)),0),(Type, (TEXT, Ascending)),(MonthYear, (NUMERIC, Ascending))))
Pic 1 : In Sorted table (first type,second monthyear) both expression generates the same and true result.
Pic 2 : In unsorted table (first monthyear) both expression generates different result. Only expression with aggr one works correctly.
Hope it helps...
It looks so simple, But when i include dimension i have to get MOM as per the dimension.