set analysis restrict

Wed, 12 Jun 2013 10:38:14 GMT

I use set analysis to create “Sum 12 last month amount “ column

When I select one customer it work good , But when I select country

The “Sum 12 last month amount “ give me the amount for all customers and not the

“Sum 12 last month amount” for each one of them.

Why?

year	month	Customer name	country	Current month amount	Sum 12 last month amount
2013	2	AAA	A	100	5000
2013	2	BBB	A	200	5000
2013	2	CCC	A	300	5000

Maybe I need somehow to add the “customer” to the formula

Here my set analysis

=sum({<Calendar_Date= {">=$(=MonthStart(Max(Calendar_Date), -11))<=$(=MonthEnd(Max(Calendar_Date)))"},Calendar_Year=, Calendar_Month= , [Calendar Month/Year], From_MonthYear=, To_MonthYear= ,Calendar_MonthName= >} Total_Amount )

Thank you

topic set analysis restrict in QlikView

set analysis restrict