Solved

[microwin88x]

Solved

[sunny_talwar]

Like this?

Table:

LOAD ACCOUNT,

     ACTIVITY,

     GROUP1,

     GROUP2

FROM

[https://community.qlik.com/thread/218639]

(html, codepage is 1252, embedded labels, table is @1);

Link:

LOAD Distinct *;

LOAD *,

  If(ACTIVITY = '2XX', 199 + IterNo(),

  If(ACTIVITY = '3XX', 299 + IterNo(), ACTIVITY)) as ACTIVITY_LINK

Resident Table

While IterNo() <= 100;

DROP Table Table;

FACT:

Right Keep (Link)

LOAD ACCOUNT,

     ACTIVITY as ACTIVITY_LINK,

     AMOUNT

FROM

[https://community.qlik.com/thread/218639]

(html, codepage is 1252, embedded labels, table is @2);

[microwin88x]

Thank you Sunny T!

Is there any way to omit those values for example Rows 4/5/12/etc?

Because those are amounts that I not need.

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD ACCOUNT,

    ACTIVITY,

    GROUP1,

    GROUP2

FROM

[https://community.qlik.com/thread/218639]

(html, codepage is 1252, embedded labels, table is @1);

Link:

LOAD Distinct *;

LOAD *,

  If(ACTIVITY = '2XX', 199 + IterNo(),

  If(ACTIVITY = '3XX', 299 + IterNo(), ACTIVITY)) as ACTIVITY_LINK

Resident Table

While IterNo() <= 100;

DROP Table Table;

Left Join(Link)

LOAD ACCOUNT,

    ACTIVITY as ACTIVITY_LINK,

    AMOUNT

FROM

[https://community.qlik.com/thread/218639]

(html, codepage is 1252, embedded labels, table is @2);

FinalTable:

LOAD ACCOUNT,

  ACTIVITY,

  GROUP1,

    GROUP2,

    Max(AMOUNT) as AMOUNT

Resident Link

Group By ACCOUNT, ACTIVITY, GROUP1, GROUP2;

DROP Table Link;