topic aggregation in chart on some dimensions in QlikView

aggregation in chart on some dimensions

Mon, 02 Jan 2012 15:33:46 GMT

Hi,

I have a straight table with 3 dimensions, lets say Region, Country, State and a single expression SUM(Sales). I want to do the SUM(Sales) based only on Region and Country but not on State. Is it possible to do this ? What is the expression that i should use ? I tried the following set analysis but it is not working -

SUM

(
{$ < State = > } Sales
)

Thanks,

Samir

aggregation in chart on some dimensions

luciancotea — Mon, 02 Jan 2012 16:37:11 GMT

=aggr(TOTAL SUM(Sales), Region, Country)

aggregation in chart on some dimensions

Tue, 03 Jan 2012 11:33:50 GMT

Hi,

I tried this expression but it does not work when I apply filter on Region/Country (select in listbox).

Thanks,

Samir

aggregation in chart on some dimensions

Mon, 30 Jan 2012 21:33:49 GMT

I'm not the best in English, but let's go hehe, I think is like this

SUM ({ < State = > } Sales)

without $