set analysis question

Sun, 16 Jun 2013 10:07:11 GMT

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

When I select one “country” it work good , But when I select corporate

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

“Sum 12 last month amount” for each “corporate & country” (per row).

Why?

corporate	country	Current month amount	Sum 12 last month amount
amp	CANADA	100	1500
amp	AUSTRALIA	200	1500
amp	NETHERLANDS	300	1500

Maybe I need somehow to add the “country” to the formula I don’t know the syntax

Can you help me?

Here my set analysis

=sum({<Calendar_Date={">=$(=MonthStart(Max(Calendar_Date), -11))<=$(=MonthEnd(Max(Calendar_Date)))"},Calendar_YearMonth=,Calendar_Year=,Calendar_Month=,Calendar_MonthName=,Calendar_MonthNameLong=,[Calendar Month_Year]=,Calendar_MonthYear=,[Calendar Month/Year]=,From_MonthYear=,To_MonthYear= ,Calendar_Type=>} TOTAL <Corporate> Total_PrintingImp )

thank you

Re: set analysis question

swuehl — Sun, 16 Jun 2013 10:35:25 GMT

It's not about set analysis, it's about your use of the TOTAL qualifier.

If you only have two dimensions, remove the qualifier.

Or add country to the field list:

TOTAL<Corporate, Country>

Re: set analysis question

Sun, 16 Jun 2013 10:46:09 GMT

thank you

you rigth i need to remove the TOTAL qualifier and it's work

by addind country to the field list it is not working

topic Re: set analysis question in QlikView

set analysis question

Re: set analysis question

Re: set analysis question