How can I create segments (in list boxes) that are... - Qlik Community

Anonymous · ‎2018-01-24

Hi everyone,

My raw data looks like this:

Age	Gender	KPI
20	F	100
20	M	200

I would like to create new categories and have them show up in list boxes on the side, such as 'Females 20-30'. However, I also want 'Adults 20-30'. I'm unable to do this through if statements because Females 20-30 is a subset of Adults 20-30. In other words, there's data overlap between the two segments. Is there a way to get around this?

Thanks,

Yefan

Anil_Babu_Samineni · ‎2018-01-24

There is no 30 age in ur sample data?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-01-25

Yes, in my dataset there would be every variation of age and gender.

How would I be able to create a listbox of segments which sometimes overlap each other? Such as:

'Adults 20-30'

'Female 20-30'

'Female 20-25'

Thanks!

How can I create segments (in list boxes) that are subsets of each other? (i.e. overlapping data)