Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner - Specialist
Partner - Specialist

How to group columns??

I have data in following format:

YearQuarterMonthWeekSchedule HrsWorked Hours Absent HoursOvertimePlannedHolidayVacationUnplannedSickJuryBereavementPlantDepartmentJobS1S2S3
201011Week 0120019010206424121Flint Assembly01023-T-0DIE01011-1001424
201011Week 02150131193810379252Flint Assembly01023-T-0DIE01011-1001838
201011Week 0317513639762061419577Flint Assembly01023-T-0DIE01011-1001161112
201011Week 0419017812237255113Flint Assembly01023-T-0DIE01011-1001624

Now I want

1) "Planned" and "Unplanned" comes under Leave.    for example:

Leave
Planned
Unplanned

                

  2) "Holiday" and "Vacation" comes under "Planned".

  3) "Sick", "Jury" and "Bereavement" comes under "Unplanned".

  4)"S1","S2" and "S3" comes under "Shift".

How can I achieve this??

This type of grouping I want in my .qvw file when I create list boxes I want Leave,Planned,Unplanned and Shift Fields.

2 Replies
Gysbert_Wassenaar

You'll need to transform your data and create an extra field for the groups. See attached example.


talk is cheap, supply exceeds demand
jsingh71
Partner - Specialist
Partner - Specialist
Author

Hi Gysbert,

Thanks for the solution.

You make a Group which contains:

                                        Group

                                       ------------

                                      Planned

                                      Unplanned

                                      Shift

                                      Total

                                      Work

But I want 4 groups like

Leave                      Planned                        Unplanned                              Shift                

------------                 ---------------                     -------------------                          ---------------

Planned                  Holiday                           Sick                                       S1

Unplanned              Vacation                          Jury                                       S2                                               

                                                                     Bereavement                           S3

Please help how I get this.???