topic Re: Multiple Sorting on pivot table in QlikView

Multiple Sorting on pivot table

mithun_j — Tue, 12 May 2020 11:20:17 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: Multiple Sorting on pivot table

fosuzuki — Wed, 13 May 2020 08:51:20 GMT

Hi,

For the Pivot table you can have only one sorting criteria. Can't you just use a regular table instead of a Pivot? The regular table can prioritize the sort order for more than 1 column.

Re: Multiple Sorting on pivot table

mithun_j — Wed, 13 May 2020 13:45:18 GMT

Thanks Fosuzuk for your reply, but we need pivot table, since have complex caluclations.

Re: Multiple Sorting on pivot table

fosuzuki — Wed, 13 May 2020 14:16:05 GMT

IMHO, if you only 1 dimension and 3 expressions, I don't see a reason why you can't use a regular table. The pivot table layout would make more sense if you have more dimensions.

Re: Multiple Sorting on pivot table

mithun_j — Wed, 20 May 2020 09:01:53 GMT

The problem is we will be adding more dimension going forward, hence the pivot table.