Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Show only the top name

try Rank() function.

Not applicable

Re: Show only the top name

Not sure how

rank([Flavour Name]) does not work

Wrong syntax maybe?

brijesh1991
Contributor III

Re: Show only the top name

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

Re: Show only the top name

for ascending order top rank --

try this 

rank(fieldname)

for descending order top rank --

try this 

rank(-1 * fieldname)

MVP
MVP

Re: Show only the top name

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

Re: Show only the top name

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

MVP
MVP

Re: Show only the top name

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

Re: Show only the top name

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

MVP
MVP

Re: Show only the top name

PFA.

Is this what you want?

Community Browser