topic Re: Current Month-Previous Month data in Qlik in App Development

Current Month-Previous Month data in Qlik

Thu, 28 Jul 2016 17:48:38 GMT

Hi,

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'))"}

>}[Financial Loss Reserve Amount])

)

Thanks in advance

Regards,

Manu

Re: Current Month-Previous Month data in Qlik

sunny_talwar — Thu, 28 Jul 2016 18:50:43 GMT

How about this:

(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]))

)

Re: Current Month-Previous Month data in Qlik

Thu, 28 Jul 2016 18:57:45 GMT

Hi Sunny,

Thanks for your reply.

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.

Thank you,

Regards,

Manu

Re: Current Month-Previous Month data in Qlik

sunny_talwar — Thu, 28 Jul 2016 19:22:03 GMT

I think it might be helpful if you can share your application. Would that be possible to do?