topic Using field content as variable name in QlikView

Using field content as variable name

Anonymous — Wed, 01 Feb 2017 12:32:02 GMT

Hi,

I have a problem with using the content of a field as a variable name that needs to be expanded.

Consider this situation:

In the script i set these (i want the users to be able to play with these values)

LET vNiveau1Factor = 10;

LET vNiveau2Factor = 20;

LET vNiveau3Factor = 30;

LET vNiveau4Factor = 40;

INLINE table:

Niveau	Factor
Niveau 1	vNiveau1Factor
Niveau 2	vNiveau2Factor
Niveau 3	vNiveau3Factor
Niveau 4	vNiveau4Factor

CHART

Dimension (Niveau)	Expression 1: =Factor	Expression2: ?????
Niveau 1	vNiveau1Factor	I would like to have an expression here that shows 10 (or current value)
Niveau 2	vNiveau2Factor	I would like to have an expression here that shows 20 (or current value)
Niveau 3	vNiveau3Factor	I would like to have an expression here that shows 30 (or current value)
Niveau 4	vNiveau4Factor	I would like to have an expression here that shows 40 (or current value)

I would like Expression2 to show the actual value of the variables.

I can't seem to find the correct $-expansion for this case.

=$('=Factor') doesn't work....

Could any1 shine a light on this?

Thanks

Herbert

Re: Using field content as variable name

sdmech81 — Wed, 01 Feb 2017 12:57:47 GMT

Hi,

in inline table add one more colum say Value then pass those

vNiveau1Factor

vNiveau2Factor

vNiveau3Factor

vNiveau4Factor

Declare variables in front end..

Re: Using field content as variable name

sdmech81 — Wed, 01 Feb 2017 13:04:10 GMT

please check rough example fr how to pass variable to inline load

Thanks

Re: Using field content as variable name

MK_QSL — Wed, 01 Feb 2017 13:17:51 GMT

//Script

LET vNiveau1Factor = 10;

LET vNiveau2Factor = 20;

LET vNiveau3Factor = 30;

LET vNiveau4Factor = 40;

Data:

Load

Niveau,

Factor

Inline

[

Niveau, Factor

Niveau 1, vNiveau1Factor

Niveau 2, vNiveau2Factor

Niveau 3, vNiveau3Factor

Niveau 4, vNiveau4Factor

];

Create a table

Dimension

Niveau

Expression

Factor

Pick(

Match(Niveau,'Niveau 1','Niveau 2','Niveau 3','Niveau 4'),

'$(vNiveau1Factor)','$(vNiveau2Factor)','$(vNiveau3Factor)','$(vNiveau4Factor)'

)

Re: Using field content as variable name

Anil_Babu_Samineni — Wed, 01 Feb 2017 13:33:24 GMT

Manish solution works, But bit long as per my experience if we have 30 Variables then we may need to create Long Expression.

May be another solution with Inline Memory

LET vNiveau1Factor = 10;

LET vNiveau2Factor = 20;

LET vNiveau3Factor = 30;

LET vNiveau4Factor = 40;

Data:

Load * Inline

[

Niveau, Factor, Factor1

Niveau 1, vNiveau1Factor, "$(vNiveau1Factor)"

Niveau 2, vNiveau2Factor, "$(vNiveau2Factor)"

Niveau 3, vNiveau3Factor, "$(vNiveau3Factor)"

Niveau 4, vNiveau4Factor, "$(vNiveau4Factor)"

];

Create Straight Table

Dimension -- Niveau, Factor

Expressions are

1) Sum(Factor1)

Re: Using field content as variable name

Anonymous — Thu, 02 Feb 2017 10:10:54 GMT

This works up to a point, if I use an inputbox to change the value of the variable, somehow the "$(vNiveauXFactor)" does not change with it.

I got it to work using the pick-function.

Which isn't really what I was looking for, but it works and is straightforward.

Thanks for all your answers.

Re: Using field content as variable name

MarcoWedel — Fri, 03 Feb 2017 00:14:36 GMT

Hi,

if being able to change the value during runtime is the reason for using variables in the first place, then you might as well consider using Inputfields instead.

hope this helps

regards

Marco