Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
Try this expression:
=Sum({<[COLUMN B] = {'1'}>} Aggr(Sum([COLUMN C]), [COLUMN A]))
Hello!
Try this expression:
=Sum({<[COLUMN B] = {'1'}>} Aggr(Sum([COLUMN C]), [COLUMN A]))
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;