Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
spijatida
New Contributor III

Spliiting mutliple information from one row into multiple columns

Hello Everywhere,

I have a problem here and hope it is solvable.

I have a table with 2 columns (key_id, content)

An Example would be:

Key IDProperties
ID_1shape#circle$color#red$diameter#4inch
ID_2shape#circle$color#blue$diameter#4inch
ID_3shape#circle$color#red$diameter#9inch
ID_4shape#square$color#red$diameter#9inch

Now I filter on color=red and see ID_1, ID_3 and ID_4

Now I would like to continuing to filter. but due to the fact that the property is in one column I'm not able to.

Is it possible to change the row content into columns without knowing the number of properties used and have the column names be set to the property name? A property is separated by $ and the property name is before # and the value after #?

I have 100 different properties and new ones can come in on a random basis so it's hard to track and a lot of maintenance.

Thanks in advance.

Pijatida

1 Reply

Re: Spliiting mutliple information from one row into multiple columns