Variable in expression

[paulcalvet]

Hi everybody,

I have a Qlikview 11 application with the variable V_IND_GEO 

='IND_$(=Only(TABLE_NOM_GEO))';

Then, in a chart, I have an expression like this :

Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>} DISTINCT If($(V_IND_GEO) = IND_GEO, INDICATEUR_ACTIVITE)))

In Sense, i put variable in the script :

SET V_IND_GEO   ='IND_$(=Only(TABLE_NOM_GEO))';

And this expression in my chart :

Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>} DISTINCT If($(V_IND_GEO) = IND_GEO, INDICATEUR_ACTIVITE))

When I select a value for TABLE_NOM_GEO, the expressions works in QV11 but not in Qlik Sense.

Is there a difference between QV11 and Sense with the variable ?

Thanks

Paul

[#2]

Hi,

Can you try with :

Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>} DISTINCT If($(V_IND_GEO) = $(IND_GEO), INDICATEUR_ACTIVITE))

You also can try with LET rather than SET.

Regards,

Xavier.

[paulcalvet]

Bonjour Xavier,

Thanks, but this don't work (I try with let and set).

As you can see, the value of IND_GEO is not retrieve by QV.

Regards,

Paul

[#4]

Bonjour Paul,

Can you try :

SET V_IND_GEO   ='IND_' & $(=Only(TABLE_NOM_GEO));

with your initial expression :

Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>} DISTINCT If($(V_IND_GEO) = IND_GEO, INDICATEUR_ACTIVITE))

I think QlikSense doesn't evaluate correctly the nested $()

Regards,

Xavier.

[jonathandienst]

SET V_IND_GEO = '=IND_$(=Only(TABLE_NOM_GEO))';

[#6]

Or in

SET V_IND_GEO   ='IND_$(=Only(TABLE_NOM_GEO))';

$(=Only(TABLE_NOM_GEO) => Return a Null.

[paulcalvet]

Hi Xavier,

Thanks again for yur help.

This expressions doesn't work.

Yes there is a big problem with variable as you can see below...

I've tried many combiantion, but none works !!

[paulcalvet]

Hi Jonathan,

It doesn't work, this expression seems to return nothing

[paulcalvet]

No, it doesn't work.

[#10]

What is the value returned by : Only(TABLE_NOM_GEO) ?