AGGR

[priyarane]

Hi Experts,

below is my requirement and example as atacehed(Ex)

display first Crisp name to avoid duplicates for unique combination (PARENT + CSA)"

And I have attached Ead dashboard which is current one.

Thanks you,

Priya

[#2]

Hi Priya,

your aggr expression should be something like this

aggr(sum(P1),CSA ID,PARENT ID) and in the chart you should not include dimension as CRISP Parent full name.

if you still want it to happen even after adding CRISP name then you need to look in purgechar keep char functions and get the names same.

[priyarane]

Hi Deepak,,

Could you please elaborate, if you don't mind

Expression - sum(EAD)

Ex

here its not the case. We need to group the data by CSAID and PARENT(Dimensions)

Total Dimensions in my pivot table/data like below

CrispName      Parent      CSAID   Period:  P0   P1   P2   P3

Citi Bank N    Citi            0                        100 10    20    3

Citi Bank PP  Citi            0                          2    3     5    8

Citi Bank TT   Citi            5                         1     10    55  88

Result like:

CrispName      Parent      CSAID   Period:    P0     P1   P2   P3

Citi Bank N    Citi            0                        102     13    25   11

Citi Bank TT   Citi            5                         1       10    55  88

Here Parent and CSAID should be unique.

[priyarane · Accepted solution]

Ruben has answered for this, you can check it on below link

http://community.qlik.com/message/712595#712595