topic Loading expressions into QV from a file in App Development

Loading expressions into QV from a file

Thu, 03 Mar 2016 12:53:41 GMT

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

sunny_talwar — Thu, 03 Mar 2016 13:14:26 GMT

May be try it like this:

$(=if(_MetricCode='MAA',_MetricExpression))

Sample:

Thu, 03 Mar 2016 14:19:32 GMT

Oops it only works when you have one expression logic - as soon as you have 2 or more it doesn't 😞

Any ideas please ?

Thanks again

Nick

sunny_talwar — Thu, 03 Mar 2016 14:24:09 GMT

Try using set analysis instead of if statement:

$(=Only({<_MetricCode = {'MAB'}>}_MetricExpression))

Thu, 03 Mar 2016 14:32:32 GMT

Excellent - thanks again !

Nick