Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kristeljoymalapitan
New Contributor III

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

 

 

5 Replies
Channa
Valued Contributor III

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

kristeljoymalapitan
New Contributor III

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

Hi

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

Thanks

kristeljoymalapitan
New Contributor III

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

Hi Can someone help me on this please
Channa
Valued Contributor III

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

try Previous(value)*value

 

Channa
kristeljoymalapitan
New Contributor III

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

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