Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to get the addition in third column

Hi,

Image.png

in attached image I have column a and b

column a expression is =Max({<CSMmilestonename={'Build'}>}SprintNo)

and column b expression is =Min({<CSMmilestonename=-{'Build'}>}CSMsprints1)

in third column i need to get the addition of these two

that is 54+1+6+1,  '54' from column a

and '1+6+1' from b.

please help

32 Replies
abc_18
Creator II
Creator II
Author

Hi Suresh,

I am not getting proper value using your expression.

Thanks

stonecold111
Creator III
Creator III

what is the output you want

a+b

or

any other value

abc_18
Creator II
Creator II
Author

sum(a)+sum(b) should be 62 for capability name.

for each capability name it should sum up all the value under a and b column.