Split Collumn

[YoussefKacem1]

Hello Everyone 

I want to split Category Collumn into 3 Collumns  (Goal , Penalty , Own Goal) 

Thank you!

[Bill_Britt]

Hi,

You can do this with using Mid Function or Left function

table(mid(data,3,5)) as column name

for each new column

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

[BrunPierre]

Like this?

=Concat(Category ,' ,')