I am facing a issue in qlik where we need to get the difference of sum(Selected Month Year) and Sum(Previous Month Year) .
The expression is giving correct totals but it is giving me two rows for one selection. When I am selecting june it is giving me 2 rows one is for june and one is for may. I want only selected year in my table.
Please find the attached screenshot and expression I am using. Please help me with the same.
(
Sum({<[Accounting Year Month Calendar.AccountingMonthYear]={"$(=Max([Accounting Year Month Calendar.AccountingMonthYear]))"}>}[Financial Loss Reserve Amount])
-
Sum({<[Accounting Year Month Calendar.AccountingMonthYear]={"$(=Date(Addmonths(Max([Accounting Year Month Calendar.AccountingMonthYear]),-1),'MMM-YYYY'))"}
(Sum({<[Accounting Year Month Calendar.AccountingMonthYear]={"$(=Max([Accounting Year Month Calendar.AccountingMonthYear]))"}>}[Financial Loss Reserve Amount])
-
Above(Sum({<[Accounting Year Month Calendar.AccountingMonthYear]={"$(=Date(Addmonths(Max([Accounting Year Month Calendar.AccountingMonthYear]),-1),'MMM-YYYY'))"}>}[Financial Loss Reserve Amount]))
I am using it with above when no selections are there.
But the issue is when we select month year. Actually we need to give it as a master item to the users. So they will be using this master item with month year . When we select nothing then it is fine but on selection the logic with above is not working.
