topic Re: Load a variable as a field value from Excel in QlikView

Load a variable as a field value from Excel

dafnis14 — Sat, 30 Dec 2017 18:27:57 GMT

Hi,

Is it possible to achieve the following:

1. Set a variable in the script

2. Define the variable as a value in Excel field

3. Load the field from Excel and have the variable's value for that field?

Metric Code	Metric Name
100	aaa
105	bbb
107	$(VParam2) & 'zzz'

Thanks!

Re: Load a variable as a field value from Excel

settu_periasamy — Tue, 02 Jan 2018 19:14:59 GMT

Hi,

Can you explain further with example and expected output?

Re: Load a variable as a field value from Excel

uacg0009 — Wed, 03 Jan 2018 07:24:55 GMT

Hi Dafnis,

So what 's the value of the variable? do you want to make this variable into a input box to make a dynamic variable or something else?

I think there is other way to make this happened, but not adding the variable into the excel.

You can define the variable(for example, vtest) to some value. And in front-end, using if function : when the Metric Code = 107, then output is vtest.

Hope it can help you.

Thanks.

Aiolos

Re: Load a variable as a field value from Excel

Anil_Babu_Samineni — Wed, 03 Jan 2018 07:30:24 GMT

This should work

If([Metric Code] = 107, $(VParam2) & [Metric Name], [Metric Name])