topic Re: Problem with simple Aggr in QlikView

Problem with simple Aggr

PabloOrtiz — Wed, 25 Nov 2020 16:16:04 GMT

Hello, the situation is as follows:

I have a data table "Datos" and i need to get a table like this "Coste Servicio / Contrato"

This would be added by "Contrato" and get a table like this

C1 S1 5000 8000

C1 S2 1000 8000

C1 S3 2000 8000

C2 S1 1000 3000

C2 S2 2000 3000

I am using the following expression "sum(Aggr(sum(Coste), Contrato))" for "CosteContrato" but I can not get the same value in each row of "Contrato"

I attach an example.

Thenks.

asgardd2 — Thu, 07 Apr 2016 08:18:56 GMT

Add NoDistinct:

sum(Aggr(Nodistinct sum(Coste), Contrato))

stabben23 — Thu, 07 Apr 2016 08:20:01 GMT

Hi,

you need to aggr on all Dimensions, like sum(Aggr(sum(Coste), Contrato, Servicio))

Sorry, to fast answer, se above!

Chanty4u — Thu, 07 Apr 2016 08:20:46 GMT

try

=Agg(sum(Total Coste),Contrato)

vikasmahajan — Thu, 07 Apr 2016 08:25:05 GMT

Why you want aggr in this case simply sum() will give you result.

Vikas

hic — Thu, 07 Apr 2016 08:31:23 GMT

If you want to use the sum within each "Contrato" you should use

sum(Total <Contrato> Coste)

HIC

kkkumar82 — Thu, 07 Apr 2016 08:40:17 GMT

Hi use,

Like Sum(Total <Contrato> Coste)

it will give you the totals of the first dimension.

PFA

Kiran Kumar

PabloOrtiz — Thu, 07 Apr 2016 08:58:26 GMT

Thanks Henric, it works perfectly.