Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
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).
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!