Hi Qlik family,
I have three dimension field (Company, H1 & H2) .I am trying to sort dimension in pivot table as per my dimension mapping num.
When I go for the company and H1 it is showing correct sorting order but for h2 it is not correct i have tried everything but its not working.
for e.g
Rank(min(H2_NUM))
Dual(H2_DESC, H2_NUM)
Note: sorting is based on the mapping number not on measure.