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: 
bob654321
Contributor
Contributor

How to divide sum/sum using multiple if statements ?

Below is how I'm calculating my expression.

 

If Label = 'A' and Client = 'X' ,Sum(Measure),

If Label = 'B' and Client = 'Y', Sum(Measure)

If Label = 'C' and Client = 'Z', Sum(measure)/If Label = 'D' and Client = 'W', Sum(measure) )))

 

The first 2 if statements worked perfectly but the last if statement to calculate the division is not working. It doesn't display any value on the dashboard. How can I do the sum / sum using if statements ?

10 Replies
bob654321
Contributor
Contributor
Author

Marcos, is there any reason why there is a plus sign between the Sums ? The Sum(Measures) should be shown separately in each cell.