set variable in expression

Mon, 30 Jul 2012 10:40:17 GMT

Hi,

consider the following:

1. KPI table containing KPI definition along with its definition:

KPI:
LOAD * INLINE [
    KPI nr,KPI, KPI_Formula
    1, Uren, sum(KPI_Value)
    2, Omzet, AVG(KPI_Value)
    3, Marge, sum(KPI_Value)
    4, Kosten, sum(KPI_Value)
    6, Gem. loon, AVG(KPI_Value)
    7, Gem. tarief, AVG(KPI_Value)
    8, Gem. leeftijd, AVG(KPI_Value)
    11, Responstijd, AVG(KPI_Value)
    16, Verblijfsduur, AVG(KPI_Value)
    17, Doorstroom, sum(KPI_Value)
];

note: KPI_Formula may also include Set Analysis expressions

2. KPI_Value containing the KPI's values

KPI_Value:

LOAD * INLINE [

KPI nr, KPI_Value, KPI_Target

1, 32, 45

1, 45, 45

1, 36, 42

1, 54, 40

2, 450, 450

2, 444, 488

2, 455, 546

];

If i try to set it all together in a straight table or Pivot...

Dimension:

1. KPI

2. [KPI nr]

Expression:

1.=$(=KPI_Formula)

...I get will get the desired result only if select a single KPI.

This seems logical since Qlikview will have problem to evaluate and aggregate different aggregation on the same expression.

Any idea's how to solve this?

topic set variable in expression in QlikView

set variable in expression