scrioting table

[rafael5958]

What I have:

COLUMN  A	COLUMN B	COLUMN C	COLUMN D
PAUL	1	100	99
TOM	2	100	99
MARY	3	100	99
PAUL	2	100	99
TOM	3	100	99

What I need:

COLUMN  A	COLUMN B	COLUMN C	COLUMN D
PAUL	1	200	99

Hi all, what I need to do is show only when column B shows 1, or sum and show 1, 2 and 3, when it contains 1 in other row. For example, Paul in row 4 has the value 2, but it apears in row 1 with 1 too, so it is sum.

thanks

[Anonymous · Accepted solution]

Hello!

Try this expression:

=Sum({<[COLUMN B] = {'1'}>} Aggr(Sum([COLUMN C]), [COLUMN  A]))

[vishsaggi]

Try this?

Col:

LOAD [COLUMN A]  AS A,

     [COLUMN B]  AS B,

     [COLUMN C]  AS C,

     [COLUMN D]  AS D

FROM

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

(html, utf8, embedded labels, table is @1);

LEFT JOIN(Col)

LOAD A,

     Min(IF(B = 1, 1, B)) AS BVal

Resident Col

Group By A;