Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to split multiple selections from inline table?

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!

2 Replies
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.


talk is cheap, supply exceeds demand
Not applicable
Author

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