topic Re: Sorting in Pivot Table in QlikView

Sorting in Pivot Table

kolov007 — Tue, 10 Apr 2018 07:28:59 GMT

Hello, I have a problem.

QlikView does not correctly display sorting in a pivot table.

I want to sort the data in the table for the column 'sum(Sale)' within the Filial. But sorting is carried out by measurement in general, not reacting to the column Filial.

Help me please, Is it possible to sort data within each Filial?

Re: Sorting in Pivot Table

petter — Tue, 10 Apr 2018 08:42:12 GMT

You can go to the Sort tab in your Pivot Table and select the City dimension and then tick the checkbox for Sort by: Expression then put in a Rank()-function in the expression:

Rank(Sum(Sale))

Re: Sorting in Pivot Table

sunny_talwar — Tue, 10 Apr 2018 09:19:23 GMT

May be like attached

Re: Sorting in Pivot Table

tim_at_ford — Mon, 15 Apr 2019 14:57:21 GMT

Sunny

I see what you are doing in this solution. But I have another question. Can we insert sort carrots/keys like the one I have in my mockup in the individual headers of the columns?? My users wants to be able to click on the up arrow and sort in Ascending order and down arrow to sort in descending order:

Re: Sorting in Pivot Table

nkosinde13 — Wed, 23 Oct 2019 09:52:20 GMT

Hi Sunny

This example really helps.

If I have more than 2 dimensions, do I now create the 3rd one as:

Dual(dim1, Aggr(Sum (Sale), Filial, City,dim1))

OR Dual(dim1, Aggr(Sum (Sale), Filial,,dim1)) etc..

I have the same issue with about 6 dimensions and I've realised that it now takes longer to respond. Is the Dual function maybe a bit heavy on a model?

thanks

Matlotlo