4 Replies Latest reply: Mar 3, 2016 9:32 AM by N G RSS

    Loading expressions into QV from a file

    N G

      HI All,

       

      I have a ridiculous chart to create :-) with hundreds of columns (but will control show / hide via conditional to make it usable).

       

      Entering expression on screen for this volume is a nightmare, so what I want to do is load something like this...

       

       

      Metrics:
      LOAD * INLINE [_MetricCode,_Metric_Name,_MetricExpression
      MAA,   Sales    ,sum(SALES)
      ];

       

      & then have a chart that uses the expression..

       

      =if(_MetricCode='MAA',_MetricExpression)

       

      .. hoping the resulting expression column would be the sum of my sales i.e. £100

       

      ... however I am getting the 'text' as a result in the column i.e.  'sum(SALES'.

       

      Is there a way please to tell the expression the result is a formulae ?

       

      Thanks in advance

      Nick