Discussion board where members can get started with Qlik Sense.
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
You can split the sub_name field with:
subfield(sub_name,".",1) as Sex,
subfield(sub_name,".",2) as Age,
subfield(sub_name,'.',1) as sex,
subfield(sub_name,'.',2) as ageclass,