Ordering is based on the QlikView sort order for the dimension used in the level. There is no way to change that other than by:
- Changing the sort order of the dimension in the QVW
- Creating a dummy dimension (as you did) to set the sort order.
If you were sorting values of a dimension in a table, you could use the Excel sorting to set the sort order rules, but for levels there are fewer options.
I encountered a similar problem and they way i solved it is by sorting the field in the script itself to the required format and then setting the sort in the document properties to the desired format.
For instance if your level is customer type. Sort this field in the script itself in the same order you would want to generate the report in. After this in the document properties, verify the sorting order of the field is set to Load order-> Original.
This will generate the report in the same order they way values or sorted in the QVW.
another alternate option is, no matter what the sorting of values is in the tabels, you can still change the sorting of the field in the Document Properties and then generate the reports.
hope this helps.
Thanks Colin - I've tested it with a dual field but found that it reads this field in as numeric when using levels, meaning you can't use the node to represent the field name and have to write out a formula to read in the text part of that field - still works using that method though, so added to the list!