Dynamic system fields in radar chart

[#1]

Hello.

I want to create radar chart where I will be able to change expression using system table "$Field".

So I've created Listbox with system fields. Then I've created Variable  vFieldSelection "='['&[$Field]&']'".

And now I've created expression in chart like that "Sum ($(vFieldSelection))".

And everything is fine when I want to show only 1 expression from 1 selected field.

But when I select more then 1, there is no data.

I want to create more expressions for chart using next selected items.

Is there any way to get first selected field to variable, then second selected item to variable etc. so I will be able to add more expressions for next variables?

[#2]

Ok, you're right it will be easier. Here it is.

[rbecher · Accepted solution]

Here we go..

[#4]

Thank you. I've must made some mispelling or somethin.Or I had different value in dimension and that's why I had errors.

But still I'm curious tresesco solution.

[rbecher]

You should set a condition to view the chart only if something (and not too much) is selected from $Field...

[tresB]

The vField1 definition was missing a pair of parenthesis.

vField1=SubField('$(vAllFields)', ';' ,1)                  // and it works fine.

PFA

[#7]

Hi thank you. It's working, but I have spaces in tags, and then it doesn't work 😞

Any solution maybe?

[tresB]

Put '[ ]' in the variable definition like:

='['&SubField('$(vAllFields)', ';' ,1)&']'

[#9]

Thanks. It works, but still only for 1 selection, when I select 2 vals, it has no data ;-).