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

Announcements
Join us in Bucharest on Sept 18th 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.