topic Re: Reference array of Variables in QlikView

Reference array of Variables

ziadm — Wed, 25 Nov 2020 16:16:04 GMT

I have an array of variables and I have the index of the variable in a Field

The Array of variables

vRate1 = .4

vRate2=.5

vRate3=.6

I have the Value as Field and Seq (The Array index in the same Table)

I want to reference the following expression in my calculation

Fees = Value * $(vRate$(Min(Seq)) )

This does not work ..

IF statement will work fine but my array is going up to 70 indexes and it shorter to reference the index of the

variable ...

if(Seq = 1, Value * vRate1,if(Seq = 2, Value * vRate2))

Any help is appreciated

loveisfail@

Re: Reference array of Variables

Digvijay_Singh — Mon, 26 Feb 2018 18:24:36 GMT

May be this -

=Value * $(vRate$(=Min(Seq)))

Re: Reference array of Variables

ziadm — Mon, 26 Feb 2018 19:48:40 GMT

Thanks Singh

Could you please check the attached Min(Seq) takes the entire sets in the chart

Re: Reference array of Variables

Digvijay_Singh — Mon, 26 Feb 2018 20:04:11 GMT

I don't have license to view qvw, can you share expression/image or whatever changes you made?

Re: Reference array of Variables

ziadm — Mon, 26 Feb 2018 20:10:38 GMT

Add a chart with

Dimension = Seq

expressions :

Value

=Value * $(vRate$(=Min(Seq)))

Rate :

= $(vRate$(=Min(Seq)))

See the rate values is always Min of the etire data set

Thanks

Re: Reference array of Variables

ziadm — Tue, 27 Feb 2018 02:19:41 GMT

any idea

Re: Reference array of Variables

marcus_sommer — Tue, 27 Feb 2018 08:42:27 GMT

It's not possible in this way because you would need a $-sign expansion for it and those won't calculated on a row-level else global before your object is calculated and then applied to each row.

This meant you will need a conditional-statement to fetch your variables whereby a pick(match()) would be better than a nested if-loop. I mean something like:

pick(match(Seq, 1,2,3,...), $(vRate1), $(vRate2), $(vRate3), ...)

and such expression could be also outsourced in an expression-variable.

- Marcus