topic Re: Set analysis evaluation from string in App Development

Set analysis evaluation from string

Peter_QS — Wed, 13 Mar 2024 22:42:38 GMT

Hello,

I have set analysis expression stored in my database in string format and I would like to know if there's a way to evaluate this expression :

LOAD
ID_EXPRESSION
EXPRESSION
FROM [lib://$(QvdConnection)/Expression.QVD]

LET vExpression_to_evaluate = peek('EXPRESSION') // ex: "Sum({$<BOOL = {'1'}>}SALES)"

in Set Analysis (fx) window :
=$(vExpression_to_evaluate); // Is this possible ?

Any idea how to proceed ?

Thanks

Peter

Re: Set analysis evaluation from string

Lisa_P — Wed, 13 Mar 2024 23:46:36 GMT

I'm not sure about what you are trying to achieve here, is it just a matter of storing expressions in a table in the load script and utilizing them in the charts ?

Re: Set analysis evaluation from string

Lisa_P — Thu, 14 Mar 2024 00:47:41 GMT

To apply expressions on the front end, you don't need to put them into variables, just use the Dollar sign expansion with an = sign to evaluate the expression

eg. $(=Only({<ID_EXPRESSION={n}>}EXPRESSION))

Re: Set analysis evaluation from string

JonnyPoole — Thu, 14 Mar 2024 01:54:46 GMT

Perhaps its meant to store the expression outside of a single app and re-use it in multiple apps?

If that is the case I think there should be a way.

Does it work if you test a valid set analysis expression without single quotes? I would test that first. If it does work without single quotes but fails with single quotes, you might need to find a way to properly escape the single quotes by adding a preceding single quote to each single quote

replace($(vExpression_to_evaluate), chr(39), chr(39) & Chr(39))

Re: Set analysis evaluation from string

Peter_QS — Thu, 14 Mar 2024 15:53:07 GMT

Thank you all for your answers