13 Replies Latest reply: Jun 22, 2015 5:02 AM by Paul Calvet RSS

    Variable in expression

    Paul Calvet

      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