Compare selected month and previous month data

Uladzislau_H — Fri, 06 Sep 2019 11:42:37 GMT

Hi! I have one problem, and it makes me crazy!

I need to compare the selected month and previous month data. For first, I need to get these data. I have tried to get the sum of logged hours by these expressions (Moth_L this is a date):

Sum({$<Month_L = {$(=Max(Month_L) – 1)}>} Log_Hours) - for previous month

Sum({<Month_L = {">=$(=Date(MonthStart(Max(MonthYear),-1),'MMM-YY'))<=$(=Date(MonthStart(Max(MonthYear),-1),'MMM-YY'))"}>} Log_Hours)

and a few other expressions

But they return 0.

I think that's because I have selected Month_L in the filter. And when have added Month_L in the expression like an exception:

sum({$<Month_L = {$(=Max(Month_L)-1)}, Month_L=>} Log_Hours)

And I get the sum working hours for all months.

So, how can I get the sum of hours by the previous month for comparing with the selected month?

p.s. I tried to use these sources:

https://community.qlik.com/t5/New-to-QlikView/Comparing-Current-Month-and-Previous-Month-Sales/m-p/590815#M108479

https://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting

Re: Compare selected month and previous month data

Uladzislau_H — Sat, 07 Sep 2019 08:41:01 GMT

This expressions is correct:

Previous month:

Sum({<Log_Month = {">=$(=MonthStart(AddMonths(Max(Log_Month), -1)))<=$(=MonthEnd(AddMonths(Max(Log_Month), -1)))"}>} Log_Hours)

Selected month:

Sum({< Log_Month = {">=$(=MonthStart(Max(Log_Month)))<=$(=MonthEnd(Max(Log_Month)))"}>} Log_Hours))

topic Compare selected month and previous month data in App Development

Compare selected month and previous month data

Re: Compare selected month and previous month data