topic Re: KPI calculation problem in App Development

KPI calculation problem

felix_kraemer — Fri, 06 Jul 2018 08:05:36 GMT

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?

Name	Area	Sum(Revenue)	Sum(Parts)	Kennzahl Umsatz / Teile ("Bereich E")
Name1	Area A	1000	0	2
Name1	Area B	5000	0	10
Name1	Area C	2500	0	5
Name1	Area D	3000	0	6
Name1	Area E	120000	500	240
Name1	Area F	10000	0	20

Many thanks,

Felix

sunny_talwar — Fri, 06 Jul 2018 15:37:01 GMT

Try this

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

felix_kraemer — Mon, 09 Jul 2018 07:33:59 GMT

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