Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It returned the right value (the name of the indicateur wich is selected :
Maybe it's because the Only() function is a graphical function (and V_IND_GEO is evaluated in the script).
Can you try with :
Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>} DISTINCT If('IND_$(=Only(TABLE_NOM_GEO))' = IND_GEO, INDICATEUR_ACTIVITE))
Hi Paul,
Pls try this expression
Avg({$<ANNEE = {$(=Max(ANNEE))}, FINESS = P(FINESS)>}
DISTINCT
$(=if('$(=V_IND_GEO)' = 'IND_GEO', INDICATEUR_ACTIVITE)))
by setting the same variable like
SET V_IND_GEO ='IND_$(=Only(TABLE_NOM_GEO))';
Thanks,
Vignesh
Vignesh,
This is the result, this expression doesn't work :