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: 
felix_kraemer
Contributor III
Contributor III

KPI calculation problem

Dear all,

I have the following challenge:

I have a table containing following fields Name, Area, Sum(Revenue) and Sum(Parts).

I want to form a measure of revenue and parts. And all Areas(A-F) should be divided by the value of Sum(parts) of area E.

Can someone help me with this formula please?

NameAreaSum(Revenue)

Sum(Parts)

Kennzahl Umsatz / Teile ("Bereich E")

Name1Area A100002
Name1Area B5000010
Name1Area C250005
Name1Area D300006
Name1Area E120000500240
Name1Area F10000020

Many thanks,

Felix

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(Revenue)/Sum(TOTAL <Name>  {<Area = {"Area E"}>} Parts)

View solution in original post

2 Replies
sunny_talwar

Try this

Sum(Revenue)/Sum(TOTAL <Name>  {<Area = {"Area E"}>} Parts)

felix_kraemer
Contributor III
Contributor III
Author

Many thanks Sunny, as I am just starting to work with Qlik I really appreciate your help.