topic Re: AGGR in QlikView

AGGR

priyarane — Thu, 12 Feb 2015 08:42:42 GMT

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

Re: AGGR

Gysbert_Wassenaar — Thu, 12 Feb 2015 09:51:28 GMT

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

Re: AGGR

priyarane — Thu, 12 Feb 2015 10:10:35 GMT

Hi Gysbert,

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

Thank you

Re: AGGR

Gysbert_Wassenaar — Thu, 12 Feb 2015 10:21:19 GMT

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 ...

Re: AGGR

priyarane — Thu, 12 Feb 2015 10:29:41 GMT

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.

Re: AGGR

Gysbert_Wassenaar — Thu, 12 Feb 2015 10:40:39 GMT

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

Re: AGGR

priyarane — Thu, 12 Feb 2015 10:57:37 GMT

Hi Gysbert,

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

Re: AGGR

priyarane — Thu, 12 Feb 2015 13:22:57 GMT

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

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