topic Re: Aggr and selections in QlikView

Aggr and selections

Tue, 29 Nov 2011 16:01:36 GMT

Hi eveyrone,

Is it possible to by pass the selection for the aggr function ?

My example is simple :

My first table ignores the selection with a set analysis

In my second table, I do the same, but with the aggr function, the selections is active

I want to use the aggr function because i have another calcul with the rank function in my application.

Someone can help me to by pass this problem ?

Thanks

Tue, 29 Nov 2011 16:02:43 GMT

(To be precise, I want that my table 2 ignores the selections)

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 17:08:33 GMT

Hi,

Try with this expression in table 2 instead

Only({1} Aggr(Sum({1} SALES.SALES), TYPE.PRODUCT_NAME))

Hope that helps.

Miguel

Tue, 29 Nov 2011 17:24:19 GMT

thanks ! it works!