topic Period over Period Comparison using GetFieldSelections in QlikView

Period over Period Comparison using GetFieldSelections

Anonymous — Thu, 20 Mar 2014 17:40:43 GMT

I am currently using flag in my calendar to calculate MTD, LastMTD, QTD, LastQTD, YTD and LastYTD. I use these flags in my expressions and they work perfect. What I would like be be able to do is to do the same thing, but allow the user to select a MonthYear. These values will then be need to recalculated based on the MonthYear chosen.

My expression for MTD is as follows:

Sum({1<FACTTYPE={'CHARGEOFF'}, CurMTDFlag={1}>}AMOUNT) - (Sum ({1<FACTTYPE={'RECOVERY'},CurMTDFlag={1}>}AMOUNT) + Sum ({1<FACTTYPE={'RESTITUTION'}, CurMTDFlag={1}>}AMOUNT))

I am open to all suggestions.

Thanks in advance.

Temieka

Re: Period over Period Comparison using GetFieldSelections

Thu, 20 Mar 2014 17:43:32 GMT

setting the flags for period over period calculations wont work when you wanted these to act based on calendar selections. you will have to go with set analysis ... ex: sum({<Year ={'$(=max(Year-1))'}>}Sales)

Re: Period over Period Comparison using GetFieldSelections

Anonymous — Thu, 20 Mar 2014 17:46:49 GMT

You are correct. I know I would need to remove the flags, but I just don't know how to set up the expression. Thanks for responding.