Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
seidydelacruz
Contributor II
Contributor II

Trouble with sorting Pivot Table with more than one Measures (Column)

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.

one measure sorting works.pngtwo measures sorting doesnt work.png

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

Labels (2)
0 Replies