topic How to calculate previous month data with current selected one in QlikView

How to calculate previous month data with current selected one

Wed, 29 Sep 2010 06:23:28 GMT

Hi,

i have a field year contains jan,feb,mar........with sum(sales) as another field.

i need to calculate the difference between current selected month and previous month.(ie)if i selected feb month then the result should find difference between jan and feb.....

pls,help me out thanks in advance.

How to calculate previous month data with current selected one

vgutkovsky — Wed, 29 Sep 2010 08:06:46 GMT

There are several ways to do this. The best methods use set analysis. Within set analysis, then, there are several different approaches. For example: sum( {$<MonthYear = {$(#=Only(MonthYear)-1)}>} Sales ). This was taken directly from the Help file; search for "set analysis" for more details and other ideas (the above is not the simplest solution in your case).

Regards,

Re: How to calculate previous month data with current selected one

kaushalview — Thu, 12 May 2011 12:58:26 GMT

Koushik

Use given expression for ur problem

PMTD=sum({$Year={$(=max(Year)-$(=if(max(Month)=1,1,0)))},Month={$(=Month(addMonths(Max(orderDate),-1)))}>}Sales)

Regrads

Kaushal Mehta