Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.