How to get the addition in third column

[abc_18]

Hi,

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

[qlikview979]

Hi,

As per your data

In pivot table  like

Dimension:-Capabilityname,Milestonename

Expression 1:-Sum(Column1),

Expression 2:- Sum(column2),

Expression 3:- Sum(Column1)+Sum(column2),

then go to presentation tab select  "Capabilityname "and click on partial sums.

Note:- in script level write where condition like

where [Capability Name]<>'Release 2-Get a Card';

It will give correct result.

Regards

[antoniotiman]

Try

RangeSum(Top(Max(SprintNO),1,NoOfRows()))+RangeSum(Top(Min(CSMsprints1),1,NoOfRows()))

[abc_18]

Hi Antonio,

Thanks for your help.

I tried your expression, but not getting proper value.

[antoniotiman]

See Attachment

[abc_18]

Hi Antonio,

Thanks for your help.

may be I am missing something .

Please check my Qvw file, I am getting wrong value,It's summing up all the value for that particular Capability name.

Thanks in advance

[antoniotiman]

See Attachment.

[abc_18]

Hi Antonio,

Thank you very much for taking the time to get this to work for me.

I have one question, Is it possible to show that value in only one row, here value 62 is coming in all row for the first capability name.

, and if I click on '-' symbol that is summarizing then I am getting '0' for that particular row.

[stonecold111]

=Max({<CSMmilestonename={'Build'}>}SprintNo)+Min({<CSMmilestonename=-{'Build'}>}CSMsprints1)

Try to use this...

[stonecold111]

or rangesum(Max({<CSMmilestonename={'Build'}>}SprintNo),Min({<CSMmilestonename=-{'Build'}>}CSMsprints1))

use this...

[antoniotiman]

See Attachment.