Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
felix_kraemer
New 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

Re: KPI calculation problem

Try this

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

2 Replies

Re: KPI calculation problem

Try this

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

felix_kraemer
New Contributor III

Re: KPI calculation problem

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