Dynamic values with set analysis in Variable Input

[wunderch]

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

[Rongtianliao_SDG]

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

[wunderch]

Hi Vivi,

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

Regards

Chris

[Rongtianliao_SDG]

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