Setup multiple sorting in pivot table in qlikview

mithun_j — Wed, 25 Nov 2020 16:16:04 GMT

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 Name	No of Trades	No of false	% of False Trades
AAAAA	20	5	25%
BBBBB	20	5	50%
CCCCC	30	3	10

Expected Output

Trader Name	No of Trades	No of false	% of False Trades
BBBBB	20	5	50%
AAAAA	20	5	25%
CCCCC	30	3	10

Re: Setup multiple sorting in pivot table in qlikview

chrismarlow — Sat, 16 May 2020 14:28:59 GMT

Hi,

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

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

Cheers,

Chris.

topic Re: Setup multiple sorting in pivot table in qlikview in QlikView

Setup multiple sorting in pivot table in qlikview

Re: Setup multiple sorting in pivot table in qlikview