topic Re: Read variable value by name in QlikView

Read variable value by name

mnbeemster — Sat, 16 Nov 2024 21:15:21 GMT

Is it possible to dynamically read the value of a variable:

load if(year(referentie_datum) = 2018,
$(v_kosten_laden_lossen_18),
$(v_kosten_laden_lossen_19)
)
as var_value

I want to get rid of the year clause. Something like:

$(v_kosten_laden_lossen_& right(year(referentie_datum,2))

marcus_sommer — Wed, 13 Mar 2019 11:01:54 GMT

I think I wouldn't use multiple variables for such a case else just a mapping like:

map: mapping load * inline [
Jahr, Wert
2018, 1
2019, 2];

and then:

load *, applymap('map', year(referentie_datum), 'any default value') as var_value
...

- Marcus

mnbeemster — Wed, 13 Mar 2019 11:19:45 GMT

Hi Marcus,

thanks for helping, but I have more than one 1 variable:

Var1 ---- value 2018 ---- value 2019
Var2 ---- value 2018 ---- value 2019
etc

Next year, there will be value 2020

marcus_sommer — Wed, 13 Mar 2019 11:23:33 GMT

It's just an example and you could simply extend the mapping-table to all years/values you need.

- Marcus