topic sorting issue in QlikView

sorting issue

amien — Wed, 27 Jan 2010 10:36:48 GMT

What i want is that all Teams are grouped first (Based on the first 3 letters) .. and then ordered by Progress. See attachment.

See BBB Team should look like this:

BBB.005 , Text, 60
BBB.012 , Text, 40
BBB.022 , Text, 30
BBB.002 , Text, 15
BBB.003 , Text, 10
BBB.004 , Text, 10


LOAD * INLINE [
Team, Description, Progress

AAA.002 , Text, 5
BBB.002 , Text, 15
BBB.003 , Text, 10
BBB.004 , Text, 10
BBB.005 , Text, 60
BBB.012 , Text, 40
BBB.022 , Text, 30
CCC.027 , Text, 5
CCC.028 , Text, 65
CCC.032 , Text, 55
CCC.033 , Text, 30
CCC.039 , Text, 15
];

sorting issue

oxiofrt — Wed, 27 Jan 2010 13:22:42 GMT

Hope this will help.
If first 3 caracters are the team (and probably last 3 are the members of the team), you should probably create the team dimension in the script.

sorting issue

amien — Wed, 27 Jan 2010 13:56:42 GMT

the output is ok .. only think is that i dont want to see AAA dimension .. when i remove that one .. it is just sorted on progress and not on team anymore

sorting issue

oxiofrt — Wed, 27 Jan 2010 14:09:03 GMT

Infact the matter is that you would like to sort the same column (Team) by 2 sorts : left(team,3) first and then progress.

In straight table, you can hide columns (you can't with pivot table). But you will not have subtotals... (see attachment)

sorting issue

amien — Wed, 27 Jan 2010 16:04:52 GMT

Thanks