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: 
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
antoniotiman
Master III
Master III

Try

Alt(a,0)+Alt(b,0)

abc_18
Creator II
Creator II
Author

using this formula I am getting column 'a+b' data, but my b column data should come from 1 and result should be

'54+1+6+1'

54 is for Build from column a

and 1+6+1 is for '=-Build' from column b

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Try like this:

=Sum(Aggr(Max({<CSMmilestonename={'Build'}>}SprintNo), CSMmilestonename))

=Sum(Aggr(Min({<CSMmilestonename=-{'Build'}>}CSMsprints1), CSMmilestonename))

abc_18
Creator II
Creator II
Author

For column a and b by using above expression as mentioned in my original post I am getting correct .

how to get addition in third column  that is one level down.

output should be 54+1+6+1=62

antoniotiman
Master III
Master III

RangeSum(Top(Sum(a+b),1,NoOfRows()))

or provide sample data

Anonymous
Not applicable

rangesum(a,b)

Anonymous
Not applicable

Hi Shikha,

The problem here is due to nulls. If you add  null to any value, the result will be a null.

So use something like this

(IF(isnull([Column a]),0,[Column a])+

IF(isnull([Column b]),0,[Column b])

) as Column C

abc_18
Creator II
Creator II
Author

Hi Antonio,

Not working using  Rangesum function.

Attaching sample file, Please check

abc_18
Creator II
Creator II
Author

Hi Fayez,

Not getting proper output ,attaching sample data.

Output should be sum of both column