topic Re: Aggregate on Dynamically changing Dimensions in QlikView

Aggregate on Dynamically changing Dimensions

mosha231 — Sun, 11 Feb 2018 08:49:04 GMT

I am facing issue with aggregating on different dimensions.

Let's say i have 10 dimensions in one list box and i want to aggregate measure on only those dimensions which are selected in Listbox.

Ex : - 1,2,3,4,5,6,7,8,9 are the dimensions and measure is sales i want to aggregate sales on dimensions selected

i selected 2,4,5 dimensions - sum(aggr(sales,2,4,5)) is what i want

Can anyone please help

Thanks in Advance!!

Anil_Babu_Samineni — Sun, 11 Feb 2018 08:56:25 GMT

Please post sample qvw?

MK_QSL — Sun, 11 Feb 2018 13:51:20 GMT

What exactly you want to do after creating this expression.

We are using Aggr when you want to use more than one Aggregation in a single expression.

i.e. More than one from Min, Max, Sum, Count, Avg etc

If you simply want to do sum as per your question

sum(aggr(sales,2,4,5))

You can simply use SUM(sales) which will give you same result.

You don't need to use

SUM(Aggr(SUM(Sales),1,2,3,4))

mosha231 — Sun, 11 Feb 2018 15:11:26 GMT

I want to aggregate my sales measure on basis of dimension selections or you can say i want to group by my measure on basis of dimension selection.

MK_QSL — Sun, 11 Feb 2018 17:29:59 GMT

But if you are using this expression on any chart / table, then you need only SUM(sales)

Otherwise

SUM(aggr(Sum(sales) ,f1,f2,f3)

will give you same result as

sum(sales)

I still don't understand your use case for this requirement.

mosha231 — Mon, 12 Feb 2018 09:14:01 GMT

Hi ,

I am using Sum(aggr(sales,f1,f2,f3)) not Sum(aggr(sum(sales,f1,f2,f3)) to aggregate

MK_QSL — Mon, 12 Feb 2018 09:21:20 GMT

Can you provide example or sample data using the above expression?

You are using only once Aggregation and still want Aggr function.

rimantasendriuk — Thu, 19 Sep 2019 09:46:00 GMT

Is this question answred? Or maybe someone can suggest the answer somewhere in other sources?