topic Re: Handle multiple properties in one field (one variable) in QlikView

Handle multiple properties in one field (one variable)

pepe2209 — Sat, 23 Nov 2013 13:05:39 GMT

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

Re: Handle multiple properties in one field (one variable)

tresB — Sat, 23 Nov 2013 13:20:08 GMT

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).

Re: Handle multiple properties in one field (one variable)

pepe2209 — Sat, 23 Nov 2013 13:29:37 GMT

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!