Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor II

Grouping field names as legends

                     

Education LevelAgeAge RangeEmployment StatusGenderChildrenWeekly EarningsYearWeekly Hours WorkedSleepingGroomingHouseworkFood & Drink PrepCaring for ChildrenPlaying with ChildrenJob SearchingShoppingEating and DrinkingSocializing & RelaxingTelevisionGolfingRunningVolunteering
Master6060-69EmployedMale066020033087040000000532532502000
Some College4140-49EmployedFemale22002003306206000600009059060000
Associate Degree2620-29EmployedFemale020020031256080152400006075340120000
Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10Header 11Header 12Header 13Header 14Header 15Header 16Header 17Header 18Header 19Header 20Header 21Header 22Header 23Header 24Header 25Header 26Header 27Header 28

From the above table, I want to calculate total hours spent on sleeping, grooming, etc. basically what I want is to have field names as legends and find aggr on them, in my expression I want this aggr(Sum(sleeping, grooming, etc), Year)

Community Browser