Sort Order with two dimensions and a expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, QlikView community

I have an easy data that has category for my companies (fish, food and machinery), Comapny then year and income

An example in the data look like this

My problem is when I want to get sort order in my table.

I have sorted the companies after the biggest income (sum(income)).

But problem is when a do that is the companies that are big in many categories are always first.

But I want the category to be alphabetical order and then I want to have sort order after category and biggest income.

So I want the order for Fish to be the biggest in that category is first and then down the list:

1. Seafood

2. Fresh Food

3, Frozen Seafood

5. Frozen Food Inc.

regards Darru

Re: Sort Order with two dimensions and a expression

sunny_talwar — Thu, 19 Jan 2017 22:43:43 GMT

May be use a calculated dimension to replace Company

=Dual(Company, Aggr(Sum(Income), Category, Company))