topic How to split 2 data from 1 column in Visualization and Usability

How to split 2 data from 1 column

Wed, 05 Oct 2016 14:25:42 GMT

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

Re: How to split 2 data from 1 column

m_woolf — Wed, 05 Oct 2016 16:05:13 GMT

You can split the sub_name field with:

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

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

Re: How to split 2 data from 1 column

martinpohl — Wed, 05 Oct 2016 16:07:39 GMT

Hello,

load

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

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

value

from yourdata;

Regards