How to split 2 data from 1 column

[#1]

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

[m_woolf]

You can split the sub_name field with:

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

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

[martinpohl]

Hello,

load

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

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

value

from yourdata;

Regards