Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Ranking on subtotals on a pivot table.

How to do the following ranking in pivot table:

  1. Create a ranking on the "partial Sums" field from the "Presentation" Tab?
  2. How to display just the Top ten and sorted by Rank in Ascending order?

DescriptionPayor% Denials# of DenialsTotal Denial AmtRanks
bankerChrysler45190$20
550$150
total240170Rank by total of denials  -2
Loanhonda602000$15000
2.51450$3000
Total3450$18000Rank by total of denials  - 1

any assistance will be appreciated

Thanks.

Tags (1)
Community Browser