topic Sum Based on other Expression in QlikView

Sum Based on other Expression

pinkzfairy — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Sum Based on other Expression

sinanozdemir — Thu, 17 Dec 2015 16:14:19 GMT

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.

Re: Sum Based on other Expression

pinkzfairy — Fri, 18 Dec 2015 13:50:06 GMT

Hi Sinan,

thanks for helping me on this, really appreciate the help

Re: Sum Based on other Expression

sinanozdemir — Fri, 18 Dec 2015 13:52:13 GMT

You are welcome and no problem.