Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.