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: 
mithun_j
Partner - Contributor
Partner - Contributor

Setup multiple sorting in pivot table in qlikview

In Qlikview, I have a pivot table with 1 dimension and 3 expressions. PFB, the sample data. In the below table the sorting of "Trader Name" should be first on the descending order of the Column "No of False", if the value for "No Of False" is same then it should be sorted on the descending order of  "% of False Trades". Please advise how we can achieve it.

Sample Data

Trader NameNo of TradesNo of false% of False Trades
AAAAA20525%
BBBBB20550%
CCCCC30310

 

Expected Output

Trader NameNo of TradesNo of false% of False Trades
BBBBB20550%
AAAAA20525%
CCCCC30310
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

If you have 1 dimension and want control over sorting like you seem to want to you should use a straight table;

20200516_1.png

Is there some reason you particularly want to use a pivot table?

Cheers,

Chris. 

View solution in original post

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

If you have 1 dimension and want control over sorting like you seem to want to you should use a straight table;

20200516_1.png

Is there some reason you particularly want to use a pivot table?

Cheers,

Chris.