Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

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)

0 Replies