How do I make a chart showing the top 3 expenses?

[nikita42]

I have a table that shows different expenses incurred by team members. How do I compare the sum of each expense type on a chart to show just the top 3 expense categories?

[gautik92]

Dimension limit->Restrict->show oly largest 3 values

[nikita42]

What expression do I use? Do I have to calculate the sum of each dimension?

[gautik92]

yes sum(expenses)

[#5]

You can use the dimension limits tab, there you can select the top 3 expenses

or

you can use calculated dimension in dimension tab with AGGR function

[jsingh71]

If you want to show top N values in pivot table then use Rank ().

[krishna20]

Hi,

Please refer this doc.

This doc much helpful to resolve your issue in different scenarios.

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

[krishna20]

Hi,

Please refer this doc.

This doc much helpful to resolve your issue in different scenarios.

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

[sujeetsingh]

Use the Dimension Limits here