Dear Qlik experts,
I’ve this Pivot table sorting fine in descending order with one measure, however when I add another measure it really doesn’t sort accurately in order.
Settings for sorting :
Prev. Carrier (Ascending)/ Sort by expression: Rank(sum( if(match(product_name, 'DBL'),1,0) ) - sum({<DateType={'FC'}> } canpol_dbl))
DBL Ben. Lev.: Sort numerically - Ascending
Broker ID (Desc)/ Sort by expression: Rank(sum( if(match(product_name, 'DBL'),1,0) ) - sum({<DateType={'FC'}> } canpol_dbl))
Group Size: Sort numerically - Ascending
I sincerely appreciate your effort, time and assistance.
Thanks & regards,
Seidy