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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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.