Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kristeljoymalapitan

What is the best approach in Multiplying values on same column?

Hi,

I need to multiply values on same column and results would be in another column per line, Please refer to attached sample screenshot for you reference.

Results can be rounded up anyway.

Appreciate on you kind assistance.

Thanks

 

 

Labels (3)
5 Replies
Channa
Specialist III
Specialist III

kristeljoymalapitan
Author

Hi

I don't have qlik view , I can't open the .qvw file

Thanks

kristeljoymalapitan
Author

Hi Can someone help me on this please
Channa
Specialist III
Specialist III

try Previous(value)*value

 

Channa
kristeljoymalapitan
Author

Hi ,what do you mean by previous value * value?
I have column1 that will multiply by row and will output to the next column
Sample:
Column1
Row1 =2
Row2 =3
Row3 =4
Row4 = 6

Output will be ..
Row1 = 144
Row2 = 72
Row3 =24
Row3 = 6