Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sum based on other column data

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??


4 Replies
MK_QSL
MVP
MVP

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
Master III
Master III

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

Anonymous
Not applicable
Author

donot forget to define group by

other way:

load A,

  Sum(B),

Amount_Type

resident xyz

group by Amount_Type

where Amount_Type = 'ZZZ'

bu

load A,

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

Amount_Type

resident xyz

group by Amount_Type

should do as well


Not applicable
Author

Try this

Temp:

Load A,

         B,

         Amount_Type

From Table;

Amount:

Load

         A,

        Sum(B) as B,

        Amount_Type
Resident Temp group by Amount_Type;