topic How to sum based on other column data in QlikView

How to sum based on other column data

Tue, 16 Sep 2014 13:55:55 GMT

Hi I have a data like this

A B Amount_Type

1 200 ZZZ

1 300 XXX

1 500 YYY

1 300 ZZZ

I want to sum column B if Amount_Type is ZZZ in straight table.

IF(Amount_Type='ZZZ',Sum(B),) Is this correct??

MK_QSL — Tue, 16 Sep 2014 14:00:21 GMT

Create a Straight Table

Dimension

Amount_Type

Expression

SUM({<Amount_Type = {'ZZZ'}>}B) // Using Set Analysis

SUM(IF(Amount_Type = 'ZZZ',B)) // Using IF

anbu1984 — Tue, 16 Sep 2014 14:01:12 GMT

SUM(IF(Amount_Type='ZZZ',B))

Anonymous — Tue, 16 Sep 2014 14:01:18 GMT

donot forget to define group by

other way:

load A,

Sum(B),

Amount_Type

resident xyz

group by Amount_Type

where Amount_Type = 'ZZZ'

load A,

if (Amount_Type='ZZZ',Sum(B)) as B

Amount_Type

resident xyz

group by Amount_Type

should do as well

Tue, 16 Sep 2014 14:07:43 GMT

Try this

Temp:

Load A,

Amount_Type

From Table;

Amount:

Load

Sum(B) as B,

Amount_Type
Resident Temp group by Amount_Type;