- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank 10 highest values in a table with two dimensions
Qlik experts
I would like to rank my measures to only show the 10 largest values in a table.
My dimesion is Date and [Navn]
The measure is avg({<ElementID= {TAX}>} [Verdi])
Thanks!
Cheers
Helge
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top 10 for each Date or overall top 10 across both the dimensions? If it is over all top 10.. then try this
If(Rank(TOTAL Avg({<ElementID= {TAX}>} [Verdi])) < 11, Avg({<ElementID= {TAX}>} [Verdi]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
May be this as mesure
If(
Rank(
avg({<ElementID= {TAX}>} [Verdi]) ) > 10 ,
avg({<ElementID= {TAX}>} [Verdi])
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top 10 for each Date or overall top 10 across both the dimensions? If it is over all top 10.. then try this
If(Rank(TOTAL Avg({<ElementID= {TAX}>} [Verdi])) < 11, Avg({<ElementID= {TAX}>} [Verdi]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Bruno
Your measure expression did not work as I was hoping for. The expression greys out the then highest values, and the rest is displayed. In addition, the table includes the entire record of measures.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Sunny
Top 10 for each date, not both dimensions. Your expression works fine, the top 10 values are listed. But the rest of the values in the table is grey. It there a way to only show the top 10 values in the table, and exclude the rest?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share an image of what you are seeing?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this for top 10 for each date
If(Rank(Avg({<ElementID= {TAX}>} [Verdi])) < 11, Avg({<ElementID= {TAX}>} [Verdi]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry my bad
try this
If(
Rank(
avg({<ElementID= {TAX}>} [Verdi]) ) < 11 ,
avg({<ElementID= {TAX}>} [Verdi])
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have more then 1 measure in your chart? If you do... then use the same condition for all the expressions
If(Rank(Avg({<ElementID= {TAX}>} [Verdi])) < 11, Measure1)
If(Rank(Avg({<ElementID= {TAX}>} [Verdi])) < 11, Measure2)
etc
and also, make sure that you have unchecked 'Include Zero Values' under Add-Ons -> Data Handling.
- « Previous Replies
-
- 1
- 2
- Next Replies »