Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
sgarim41
New Contributor III

Sorting By Groups and subgroups in straight table

Hi,

I have a straight table which have multiple groups and each group has many sub groups within them. Each group has 2 scores associated with it at the group level Score1_GRP and Score2_GRP. Similarly each sub group has 2 scores associated with it SCR1_IND and SCR2_IND.

GroupIndividualScore1_GRPScore2_GRPSCR1_INDSCR2_IND
AIA5435
AIB5454
AIC5433
BID3444
BIF3422
CIG5555
CIH5534
CIK5544

I need the 2 sorts on this table, the first one being based on the combined sum of the group score(Score1_GRP and Score2_GRP) with the highest coming first and second, the sorting of the sub groups based on the combined sum of individual scores(SCR1_IND and SCR2_IND) as follows,

GroupIndividualScore1_GRPScore2_GRPSCR1_INDSCR2_IND
CIG5555
CIK5544
CIH5534
AIB5454
AIA5435
AIC5433
BID3444
BIF3422
3 Replies
Highlighted
vvira1316
Valued Contributor II

Re: Sorting By Groups and subgroups in straight table

Sum(Score1_GRP) + Sum(Score2_GRP) + Sum(SCR1_IND) + Sum(SCR2_IND)

Sort by Expression. Place it in all dimension, click descending. Uncheck other sort options

Highlighted
sgarim41
New Contributor III

Re: Sorting By Groups and subgroups in straight table

If Score1_GRP and Score2_GRP are similar and add up to same number between different groups, i dont think this formula would work.

Highlighted
vvira1316
Valued Contributor II

Re: Sorting By Groups and subgroups in straight table

Provide sample and expected output. You may have to use set analysis, do it in script, and may be able to use autonumber to come up with a solution.