Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
Partner

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)

khan_fayez
Creator
Creator

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