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

[Gysbert_Wassenaar]

Fix your source data so that BANK OF AMERICA NA is renamed to BANK OF AMERICA PBIS.

[priyarane]

Hi Gysbert,

Its not only with BOFA, its I have shown that one example.

Thank you

[Gysbert_Wassenaar]

In that case fix the other faulty data too.

Or create a mapping table and replace the faulty values with the correct ones in the script:

MapNames:

MAPPING LOAD * INLINE [

Key, Value

BANK OF AMERICA NA,  BANK OF AMERICA PBIS

PELICAN BANK, VATICAN BANK

...etc

];

T1:

LOAD

     ...some fields...,

     applymap('MapNames', MyField) as MyField,

     ...other fields...

FROM ...

[priyarane]

Hi Gysbert,

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.

[Gysbert_Wassenaar]

That's fine, but then either leave out CrispName or define the logic that determines which CrispName value is the correct one to display.

[priyarane]

Hi Gysbert,

Not getting it, if you don't mind could you please elaborate.

[priyarane · Accepted solution]

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

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