HI ALL,
I am facing issue in qlikview to perform pivot table sorting.
Below are my dimension in table as per sequence Region, RSO, OFFICE, CODE, NAME and expression is Ach %. Now i want to perform sorting Office wise based on ACH% Expression.
But in few cases sorting is not giving me correct Output.
I have sorted Region based on Y Value and other dimension based on Ach% expression Still sorting is not giving me correct o/p in few cases.
I have attached screenshot of Output.