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: 
RogerG
Creator
Creator

Load Script Summation of certain rows based on row value

Hello,

I have a table like this

Table:

load * inline

Project, id, type, cost

P1, id1, external, 1000

P1, id2,  external, 2000

P1, id3, supplies, 3000

p1, id4, personnel, 4000

];

 

I need to create a new type called Internal

this field would be a summation of external and supplies only.

I have the master table created as 

load * inline

Project,  type, cost

P1,  external, 3000

P1, supplies, 3000

p1,  personnel, 4000

P1, Internal, 0 // I am not sure how to adjust this to add the 2 together

];

3 Replies
edwin
Master II
Master II

it sounds like what you may want is create a new field that categorizes the types:

Table:
load *, if(type='external','external','internal') as category inline [
Project, id, type, cost
P1, id1, external, 1000
P1, id2, external, 2000
P1, id3, supplies, 3000
p1, id4, personnel, 4000
];

hope that helps

edwin
Master II
Master II

this way when you filter for category=internal, it will return the types that are not external

RogerG
Creator
Creator
Author

so the equations I am generating are "Types" in this case, I can use a separate field for summation, 

The equation will be something like Externals = Externals + Supplies, (no problem here)

then

Internals = .5*(Externals - Supplies)

so the types will read

Externals

Personnel

Supplies

Internals

with their associated dollar values