Variable syntax SUM()

Wed, 24 Jun 2015 20:49:13 GMT

Hi all, looking for ways to optimize a scrip, eh I met with a scenario that is not how to solve, QlikView can do the following:

I have

METRIC:

LOAD * INLINE [

_repMetricaNo, _METRICA

1, Amount Awarded

2, Turned Amount

3, Balance Capital

4, Pending Interest

5, Flat Pending

6, Pending Debtor Insurance

7, Total Amount Amortized

8, Total Amount Cancelled

9, Cancelled Amount Capital

a, Credit Interest

b, Flat Amount

c, Debtor Amount

d, Number of Credits

e, Nro Associates

];

and

Each also is the name of a field in the fact table

vMetrica = _METRICA

Normal Form:

(Sum ({$ <$ (vSetMTD)>} [AMOUNT AWARDED])

Sought form:

(Sum ({$ <$ (vSetMTD)>} $ (vMetrica))

What I wish is that [amount awarded], function as a variable as to choose from a list I dynamically change the amount according to the value of vMetrica

That way you can make?

Re: Variable syntax SUM()

swuehl — Wed, 24 Jun 2015 21:16:24 GMT

In what context do you want to use this expression?

It should work, when you select a metric in a e.g. list box (and take care to enclose your variable in [$(vMetrica)] ).

It will not work when using the Metric as a dimension in a chart.

topic Variable syntax SUM() in QlikView

Variable syntax SUM()

Re: Variable syntax SUM()