Sum Based on other Expression

[pinkzfairy]

Hi Guys,

I would like to consult on this QlikView matter.

I have this problem on how do i sum up data resulted from expression in QlikView.

Got this column called Score A where it resulted from some calculation based on other column, on i also have this column Called Score B where it resulted from Score A * other column.

Now my problem appears when i want to sum up the value in Score B and i want to put it in other column(Score C), it seems the result shows 0 value only for everything.

My Expression : Sum(TOTAL <MD> [Score B])

Could anyone help me on this matter, i also attached the example in excel file where i want the result of Score C (Column I)as an output.

Thanks guys for the help

[sinanozdemir · Accepted solution]

Hi,

Something like this:

For Score C, the below expression gives you what you need to accomplish:

I am also attaching the qvw.

Hope this helps.

[pinkzfairy]

Hi Sinan,

thanks for helping me on this, really appreciate the help

[sinanozdemir]

You are welcome and no problem.