How to split multiple selections from inline table?

Wed, 24 Sep 2014 07:22:00 GMT

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!

Re: How to split multiple selections from inline table?

Gysbert_Wassenaar — Wed, 24 Sep 2014 12:19:12 GMT

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.

Re: How to split multiple selections from inline table?

Tue, 30 Sep 2014 08:46:13 GMT

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

topic Re: How to split multiple selections from inline table? in QlikView

How to split multiple selections from inline table?

Re: How to split multiple selections from inline table?

Re: How to split multiple selections from inline table?