Hi,
Based on the screenshot you used the field Dime1 to create the level. In this case you will have a level band for each distinct value of that field in alphabetical order.
Instead create the level by adding the custom sortered straight table into the Levels node then drag and drop the fields from it. The generated report will be sorted according the table.
Please also note that using levels slow down the reports generation speed because each row is a filter. I suggest you to evaluate to use a pivot table (Sense or native Excel) instead.
Best Regards,
Ruggero
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
