Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Variable syntax SUM()

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?

Tags (1)
1 Reply
MVP
MVP

Re: Variable syntax SUM()

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.

Community Browser