How to split multiple selections from inline table?

[#1]

Hi,

I want to plot multiple fields in a chart. When I select only one field, it works fine (example):

LOAD * INLINE[
Fields
A
B
];

The values related to those fields 'A' and 'B' are loaded from an Excel sheet.
I have a list box 'Fields', and a chart with dimensions:

- Year
- Company name

and the following expression:

$(vValue)
where vValue is a variable which is defined by: ='[' & [Fields] & ']'

This works fine when I only select one field (for example: A). But when I want to plot both fields A and B, it goes wrong.
When I select multiple fields, [Fields] is equal to: A, B
So vValue will be: [A, B] and $([A, B]) does obviously not work..

I'm looking for a way to split [Fields] with delimitier ',' in a way that I can use those multiple fields seperately to plot the associated values.

I tried several things like GetFieldSelections and SubField, but can't get the result I want..

Thanks in advance!

[Gysbert_Wassenaar]

Your approach won't work. Try this instead: Customizable Straight Table. Note, this is not just for straight tables and pivot tables, but can be used for other chart types too.

[#3]

Sorry for the late response. Conclusion is that my approach won't work indeed. Thanks for the link, I will try!