Issue with Above function

Fri, 24 Jun 2016 11:47:05 GMT

Hi All,

I need help on below issue where we need data as per below logic

MOM % = (Current month - Previous Month / Previous Month)

Formula: =(Current month – previous month)/previous month%

Month	Bookings	Margin %	Funnel Weighted	Funnel Unweighted	M-O-M %	Y-O-Y%
Jan	10				10
Feb	15				50%
Mar	25				67%
Apr	30				20%
May	10				-67%

for this when we are using below formaulae we are receving July month data which actually we should not be there aswe are in June

=if(Month = 'Jan',sum({<Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate),

(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))

(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))

(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))))

jan	18736
feb	18417
mar	36099
april	31215
may	24317
jun	7160
jul	100

Thanks in Advance!

Timba!

Re: Issue with Above function

sunny_talwar — Fri, 24 Jun 2016 12:11:41 GMT

May be this:

=if(Month = 'Jan',sum({<Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate),

If(Above(Sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}, Stage={'S'}, [Interco Flag]={'External'}>}[Booking Amount Euros] * Rate)) > 0,

(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))

(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))

(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}

,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))))

topic Issue with Above function in QlikView

Issue with Above function

Re: Issue with Above function