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.

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

Sort Pivot Table first by then by


I have a pivot table with revenue calculations based on weeks ago.  An example is pictured below:

SupplierLast Week Revenue-2 Weeks Revenue-3 Weeks Revenue

Company A



Company B$56,000$54,000
Company C$100$0$0
Company D$100$500$0
Company X$100$500$1,000

Currently I have the table only sorting by Last Week Revenue but in the event of a tie, I need the next best performer.  I need an expression to sort this first by Last Week Revenue, then by -2 Weeks Revenue, then by -3 Weeks Revenue.

So in the event of a tie, the sorting will be by the next measure.  In this example, I would need the sorting to be...

  1. Company A
  2. Company B
  3. Company X
  4. Company D
  5. Company C

Anything helps.  Thanks!

0 Replies