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: 
Anonymous
Not applicable

Addition or subtraction of values in rows

Hello Experts,

i want to add and subtract the values received in load statement as shown in below table.

i have all data available in load statement except the calculated values marked in Yellow.

Please note that each value is received in a separate load statement and joined together. 

Is it possible to do this?

2019-06-12_16h03_07.png

 

For your information the number of rows are fixed.



thanks in Advance

13 Replies
Anonymous
Not applicable
Author

Hello,

i managed it to do using a variable as below.

2019-06-14_09h48_25.png

but i was wondering if i can avoid one more resident load and instead hust load 2 values from 2 variables in load statement like . It doesn't give any error but no values in the table.


SUMB1:
LOAD
'B-A' as SGroup,
($(vB) - $(vA))as StockValue;

Channa
Specialist III
Specialist III

can you try preceding load

 

like

 

Load
'A-B' as Desc,(ValueB-ValueA) as Value ;


LOAD
IF(Desc='B', Value) as ValueB ,
IF(Desc='A', Value) as ValueA
FROM [lib://Source/Grouping.xlsx]
(ooxml, embedded labels, table is Sheet1) where WildMatch(Desc,'B','A') ;

Channa
sunny_talwar

Check attached

image.png

Anonymous
Not applicable
Author

Thanks Genius 🙂