topic scrioting table in QlikView

scrioting table

rafael5958 — Wed, 13 Jun 2018 15:48:28 GMT

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

Re: scrioting table

Anonymous — Wed, 13 Jun 2018 16:03:00 GMT

Hello!

Try this expression:

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

Re: scrioting table

vishsaggi — Wed, 13 Jun 2018 16:05:55 GMT

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;