Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
YoussefKacem1
Contributor II
Contributor II
‎2022-11-22 06:00 AM

Split Collumn

Hello Everyone 

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

 

 

Thank you!

Preview file
4 KB
550 Views
0 Likes
2 Replies
Bill_Britt
Former Employee
Former Employee
‎2022-11-22 07:02 AM

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

 

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
525 Views
BrunPierre
Partner - Master
Partner - Master
‎2022-11-22 07:05 AM

Like this?

=Concat(Category ,' ,')

523 Views