Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

set analysis question

Hi

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

2 Replies
Highlighted
MVP
MVP

Re: set analysis question

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>

Highlighted
Not applicable

Re: set analysis question

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