Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to divide row 1 by row 2 in Pivot or straight table

Hi

 

RegionAmountResult
a20
b210
a30
b310
a405
b8
a60
b415

i want to divide region  = a/b that means 20/2 = 10 result

please help on this

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

See attached

Dimension:

Region

Code

Expressions:

=Sum(Amount)

=if(Region = 'b',Aggr(Above(Sum(Amount)),Code)/sum(Amount))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

7 Replies
sunny_talwar

How is a and b repeating in table? Is there another dimension here?

Not applicable
Author

yes another dimension also there

sunny_talwar

May be this (assuming there is only one other dimension):

Sum(Amount)/Above(Sum(Amount))

Not applicable
Author

No its not working

vinieme12
Champion III
Champion III

See attached

Dimension:

Region

Code

Expressions:

=Sum(Amount)

=if(Region = 'b',Aggr(Above(Sum(Amount)),Code)/sum(Amount))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

awseome