Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
pinkzfairy
New Contributor II

Sum Based on other Expression

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

1 Solution

Accepted Solutions
sinanozdemir
Valued Contributor III

Re: Sum Based on other Expression

Hi,

Something like this:

Capture.PNG

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

Capture.PNG

I am also attaching the qvw.

Hope this helps.

View solution in original post

3 Replies
sinanozdemir
Valued Contributor III

Re: Sum Based on other Expression

Hi,

Something like this:

Capture.PNG

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

Capture.PNG

I am also attaching the qvw.

Hope this helps.

View solution in original post

pinkzfairy
New Contributor II

Re: Sum Based on other Expression

Hi Sinan,

thanks for helping me on this, really appreciate the help

sinanozdemir
Valued Contributor III

Re: Sum Based on other Expression

You are welcome and no problem.