Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kolov007
New Contributor III

Sorting in Pivot Table

Hello, I have a problem.

QlikView does not correctly display sorting in a pivot table.

Screenshot_3.png

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?

1 Solution

Accepted Solutions

Re: Sorting in Pivot Table

May be like attached

Capture.PNG

3 Replies
MVP
MVP

Re: Sorting in Pivot Table

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

May be like attached

Capture.PNG

Highlighted
tim_at_ford
New Contributor III

Re: Sorting in Pivot Table

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:

Sorting Question.PNG