Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
mithun_j
Partner
Partner

Multiple Sorting on pivot table

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
4 Replies
fosuzuki
Partner
Partner

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.

mithun_j
Partner
Partner
Author

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

fosuzuki
Partner
Partner

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.

mithun_j
Partner
Partner
Author

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