Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to split 2 data from 1 column

Hello there,

Here is my data (image attached), data represent sex and ages, i need to be able to split them in 2 columns in order to be able to create a graph like this (Facebook_split).

What would be the best in Qlikview to recreate the grah called "Facebook_split" ? and how do you split the values ?

Thanks for your help

JP

Tags (2)
2 Replies
mwoolf
Not applicable

Re: How to split 2 data from 1 column

You can split the sub_name field with:

subfield(sub_name,".",1) as Sex,

subfield(sub_name,".",2) as Age,

martinpohl
Not applicable

Re: How to split 2 data from 1 column

Hello,

load

subfield(sub_name,'.',1) as sex,

subfield(sub_name,'.',2) as ageclass,

value

from yourdata;

Regards