topic Dynamic values with set analysis in Variable Input in App Development

Dynamic values with set analysis in Variable Input

wunderch — Mon, 29 Mar 2021 10:41:13 GMT

Hi guys,

I want to sort my Piovttable by dynamic values with the "Variable Input" - Object.

I have the following values:

='~A-Z|'
&'sum(SP_LMNG)~PlatzMenge ▲|'
&'-1*sum(SP_LMNG)~PlatzMenge ▼|'
&'sum(aggr(sum({<Erstelldatum={">=$(vDatum_MIN)<=$(vDatum_MAX)"} >}AEBMNG), SP_PRGR))~Absatz ▲|'
&'-1*sum(aggr(sum({<Erstelldatum={">=$(vDatum_MIN)<=$(vDatum_MAX)"} >}AEBMNG), SP_PRGR))~Absatz ▼'

The sortOrder for "PlatzMenge" works fine, but für "Absatz" it doesn't work.

I think the reason is the set analysis in the value, because without the set analysis argument it also works.

Ist this a bug or do I something wrong??

Thanks for your replys!

Chris

Re: Dynamic values with set analysis in Variable Input

Rongtianliao_SDG — Thu, 08 Sep 2022 13:53:53 GMT

Hey Chris,

Thanks for posting this question. I have encountered exactly the same question, have you gotten any solution for the 'Absatz' yet?

Thanks in advance.

Vivi

Re: Dynamic values with set analysis in Variable Input

wunderch — Thu, 08 Sep 2022 14:05:04 GMT

Hi Vivi,

sorry, but I didn't get any answer or solution for this problem.

Regards

Chris

Re: Dynamic values with set analysis in Variable Input

Rongtianliao_SDG — Fri, 09 Sep 2022 17:42:13 GMT

Hi Chris,

I got the solution for this issue. Change the parameters in your variable in the set analysis from single quote to double quote, so the Variable Input could read it as a string, for example:

In the case above, you would need to change the values in submarket from single quote to double quote, it worked out for me.

Good luck!

Best,

Vivi