Sales Comparison for current vs prior month

[#1]

Can anyone please assist me ,i am new in qlikview , set analysis is challenging me , i have data for 2015 from january to july .

i want to compare sales for current month to Prior month e.g July vs June .i tried to use this expressions but its not working sum ::  current Month =({<Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'}>}TranAmt) and Prior month=sum({<Year={'$(vMaxYear)'},Month={'$(vPriorMonth)'}>}TranAmt).

Variables:

vMaxYear =max(if(vCalenderType='Fiscal',[Fiscal Year],Year))

vMaxMonth=max(if(vCalenderType='Fiscal',[Fiscal Month],Month))

vPriorMonth= vMaxMonth

Assist , if anyone has an example please post it , i am working on my first project.

[maxgro]

do you have a date field? if yes this is (often) a set analysis expression for previous month (d is my date field)

=Sum({$<d={">=$(=(addmonths(MonthStart(today()),-1)))<=$(=(MonthEnd(addmonths(MonthStart(today()),-1))))"}>} TranAmt)

[subathra]

Hi try like this,

sum({$<Month={$(=max(Month))}>}Tranamt)-sum({$<Month={$(=max(Month)-1)}>}Tranamt)