Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.