Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kolov007
Contributor III
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
sunny_talwar

May be like attached

Capture.PNG

View solution in original post

4 Replies
petter
Partner - Champion III
Partner - Champion III

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))

sunny_talwar

May be like attached

Capture.PNG

tim_at_ford
Contributor III
Contributor III

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

 

 

 

nkosinde13
Creator
Creator

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