Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

is this possible to keep the sort in a pivot table?

Hi,

I have created a pivot table and sort it by the Y-value, however this works when the data is collapsed, when I expand the information the sort is lost.

How can I keep the sort?

I have remove the check marks from all the other sorts (other fields) but the behavior persists.

Any idea?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: is this possible to keep the sort in a pivot table?

it's can be anything numeric value which you want to sort

for instance =sum(profit) will sort you dimension by value of profit

View solution in original post

7 Replies
Highlighted
Specialist
Specialist

Re: is this possible to keep the sort in a pivot table?

Hello, Roberto!

You can use an expression for sorting. As far as know when you at Sort tab you can manage different sort algoritms for all included dimensions.

Highlighted
Creator II
Creator II

Re: is this possible to keep the sort in a pivot table?

What should be the expression? or how should it looks like?

Highlighted
Anonymous
Not applicable

Re: is this possible to keep the sort in a pivot table?

the sorting is hierarchical, so it depends on the order of the dimensions...

Highlighted
Creator II
Creator II

Re: is this possible to keep the sort in a pivot table?

I know, but if I disable the other sorts, it should only displays the first y-value sort, am I right?

Highlighted
Specialist
Specialist

Re: is this possible to keep the sort in a pivot table?

it's can be anything numeric value which you want to sort

for instance =sum(profit) will sort you dimension by value of profit

View solution in original post

Highlighted
Anonymous
Not applicable

Re: is this possible to keep the sort in a pivot table?

please prepare a small example...

Highlighted
Creator II
Creator II

Re: is this possible to keep the sort in a pivot table?

I have used the same condition that I have as expression and it worked.