Handle multiple properties in one field (one variable)

[pepe2209]

Hello

I have an excel document that looks like this:

ID	Variable1	Variable2
1	A	AA, CC, EE
2	B	BB, CC
3	C	AA, DD, EE, FF
4	D	BB, DD

So Variable2 for each record contains multiple properties seperated by a comma.

Now if I load this in Qlikview I want to use Variable2 as a graphs-dimension in a bar-chart, where each property (like 'AA' or 'BB') is a single bar. And also that the for instance ID 1 is represented in the bars for AA, CC, and EE.

how can I achieve this?

Your help would be much appreciated.

Regards,

Peter

[tresesco · Accepted solution]

Load Variable2 field using SubField() function, like:

Load ID,

          Variable1,

          SubField(Variable2, ',') as Variable2

From <>;

Subfield() would create one record for each substring separated by comma (here).

[pepe2209]

Thanks for your comment.

This does achieve what I need, but it also multiplies the number of records and I don't want that to happen...

is it possible to do this without multiplying records?

edit-

Oh wait offcourse, by loading ID (as key variable) and subfield(Variable2, ', ') as a second table it works.

Thanks!