Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
dafnis14
Contributor III

Load a variable as a field value from Excel

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 CodeMetric Name
100aaa
105bbb
107$(VParam2) & 'zzz'

Thanks!

Tags (3)
1 Solution

Accepted Solutions

Re: Load a variable as a field value from Excel

This should work

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
3 Replies

Re: Load a variable as a field value from Excel

Hi,

Can you explain further with example and  expected output?

Partner
Partner

Re: Load a variable as a field value from Excel

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

This should work

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)