Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only the top name

Good day,

Is there a way to only show the top Flavour Name whithout using a pivot table?

Please help

See attached

Thanks

12 Replies
tresesco
MVP
MVP

try Rank() function.

Not applicable
Author

Not sure how

rank([Flavour Name]) does not work

Wrong syntax maybe?

brijesh1991
Partner - Specialist
Partner - Specialist

Three ways: First WAY: Double click on Sum(A1) to get sort indicator. Make them descending by double click on sort indicator Now go to presentation tab. find a checkbox: Max. No(1-100): specify 10 if you wanted to show top 10 Names Second WAY: First Go to Sort tab. Give your Sum(A1) descending order. Now go to presentation tab. find a checkbox: Max. No(1-100): specify 10 if you wanted to show top 10 Names Third WAY: using Rank Function as said by tres qv

Not applicable
Author

for ascending order top rank --

try this 

rank(fieldname)

for descending order top rank --

try this 

rank(-1 * fieldname)

tresesco
MVP
MVP

Sorry, I missed a part of your post. I guess it is better to use FirstSortedValue() for this. try like this:

FirstSortedValue( [Flavour Name] , Rank ( Sum(A1)) )              // assuming your ranking would be based on A1

Not applicable
Author

FirstSortedValue( [Flavour Name] , Rank ( Sum(A1)) )

this does not work, but I also forgot to add, there is more then one flavour name, I only want the first of every name to display

tresesco
MVP
MVP

i guess there is a gap between my understanding and your requirement. Can you please explain a bit more?

Better option would be if you can share app sample with requirement(expected result) described in it.

Not applicable
Author

Thanks for the reply..

I attached a small model.

The customer name and the customer ID is repeating, I want to show only the first 'Jan'', the first Koos' first 'peet' etc. and their ID and not 4 jans and 4 peets, without changing the graph to a pivot table.

Thank you

tresesco
MVP
MVP

PFA.

Is this what you want?