I'm facing sorting issue in qlik sense pivot table. I created pivot table with 6 dimensions and one expression.
My dimensions are levels starting from level 1 , level 2 to level6.
I have a field called display order from another table from where am doing left join to my fact table based on level fields and getting the display order. In pivot table sorting i took display order field for each dimension sort by expression but not working. When i took the display order field as a first dimension the order looks correct but the user don't want to see the order field as a dimension. I have tried creating sorting order in the script but no luck.
Please can someone let me know how to fix sorting order issue?
