topic Re: set analsis with variable in QlikView

set analsis with variable

souadouert — Wed, 27 Dec 2017 11:15:18 GMT

I download the expression set from a file, I have a problem with some expression when I use the variable always the result zero if I put the expression the result is correct

Re: set analsis with variable

vinieme12 — Wed, 27 Dec 2017 11:37:22 GMT

try adding an equal sign "="

$(=variable)

Re: set analsis with variable

pradosh_thakur — Wed, 27 Dec 2017 11:43:32 GMT

Try adding an extra = in variable or us an extra = inside dollar expansion

The Little Equals Sign

Re: set analsis with variable

prma7799 — Wed, 27 Dec 2017 12:04:24 GMT

Try with '='

Or check this

Set Analysis with variables

https://community.qlikview.com/thread/60838

Re: set analsis with variable

sunny_talwar — Wed, 27 Dec 2017 12:07:16 GMT

Are you just using your variable like this

vVar? Try adding a dollar sign expansion and see if that works

$(vVar)

Re: set analsis with variable

souadouert — Wed, 27 Dec 2017 12:18:40 GMT

even with =

Re: set analsis with variable

souadouert — Wed, 27 Dec 2017 12:19:38 GMT

even with =

Re: set analsis with variable

prma7799 — Wed, 27 Dec 2017 12:20:28 GMT

Please share sample app.

Re: set analsis with variable

Anil_Babu_Samineni — Wed, 27 Dec 2017 12:21:50 GMT

Can you share the variable definition you are working with?

Re: set analsis with variable

souadouert — Wed, 27 Dec 2017 12:25:22 GMT

Indicateur:

LOAD Référence as Référence_Ind ,

Indicateurs AS Indicateurs_Desc

FROM

[..\REF_IND\Spécification Base de données Pilotage Opérationnel.xlsx]

(ooxml, embedded labels, header is 1 lines, table is [Référentiel Indicateur]);

//LIST EXPRESSION

Expression_list:

LOAD RowNo() as REF_Exp,

Référence as Référence_Ind,

Indicateurs,

replace(Indicateurs,' ','') & replace(REF_Expression,' ','') as desc_expression,

Segment,

Expression

FROM

[..\REF_IND\Spécification Base de données Pilotage Opérationnel.xlsx]

(ooxml, embedded labels, table is REF_Expression);

LET myCount = peek('REF_Exp',-1,[Expression_list]);

FOR _i = 0 to $(myCount);

LET _varName = Peek('desc_expression',$(_i),[Expression_list]);

LET _varValue = Peek('Expression',$(_i),[Expression_list]);

//Now create the variables

SET [$(_varName)] = $(_varValue);

NEXT _i;

//LIST_ENTITY: