Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sgarim41
Contributor III
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
vvira1316
Specialist II
Specialist II

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

sgarim41
Contributor III
Contributor III

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

vvira1316
Specialist II
Specialist II

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.