Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

itamarchubb
New Contributor III

Sorting a column

Hi,

How do I sort the column with the blue arrow (preference to descending):

sorting.PNG

1 Solution

Accepted Solutions
sibin_jacob
Contributor III

Re: Sorting a column

Go to Sorting tab.

Then Select Country -> the select sort by expression option.

For example your expression is Sum(Sales), then write the below expression in sorting tab.

I am assuming you need to sort table order based on Review Type Null

Sum({<Review_Type-={"*"}>} Sales)


Then select Decending Order.


If you need to sort based on Review Type 'No Owner', the sort tab expression will be

Sum({<Review_Type={'No Owner'}>} Sales)


Dynamic sorting is not available in Pivot table, which is available only in Straight table.

2 Replies
sibin_jacob
Contributor III

Re: Sorting a column

Go to Sorting tab.

Then Select Country -> the select sort by expression option.

For example your expression is Sum(Sales), then write the below expression in sorting tab.

I am assuming you need to sort table order based on Review Type Null

Sum({<Review_Type-={"*"}>} Sales)


Then select Decending Order.


If you need to sort based on Review Type 'No Owner', the sort tab expression will be

Sum({<Review_Type={'No Owner'}>} Sales)


Dynamic sorting is not available in Pivot table, which is available only in Straight table.

itamarchubb
New Contributor III

Re: Sorting a column

It works, Tnx!

Community Browser