topic Re: Show only the top name in QlikView

Show only the top name

Fri, 02 Aug 2013 10:44:26 GMT

Good day,

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

Please help

See attached

Thanks

Re: Show only the top name

tresB — Fri, 02 Aug 2013 11:00:29 GMT

try Rank() function.

Re: Show only the top name

Fri, 02 Aug 2013 11:04:32 GMT

Not sure how

rank([Flavour Name]) does not work

Wrong syntax maybe?

Re: Show only the top name

brijesh1991 — Fri, 02 Aug 2013 11:09:39 GMT

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

Re: Show only the top name

Fri, 02 Aug 2013 11:12:17 GMT

for ascending order top rank --

try this

rank(fieldname)

for descending order top rank --

try this

rank(-1 * fieldname)

Re: Show only the top name

tresB — Fri, 02 Aug 2013 11:14:31 GMT

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

Re: Show only the top name

Fri, 02 Aug 2013 11:26:07 GMT

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

Re: Show only the top name

tresB — Fri, 02 Aug 2013 13:10:58 GMT

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.

Re: Show only the top name

Mon, 05 Aug 2013 05:31:57 GMT

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

Re: Show only the top name

tresB — Mon, 05 Aug 2013 05:37:08 GMT

PFA.

Is this what you want?

Re: Show only the top name

Mon, 05 Aug 2013 05:43:43 GMT

Nope,

I still need to see all the other data, like this:

Customer CustID Date Amount

Jan 5 1/4/2010 4567847

4/6/2011 7847784

5/8/2012 4563456

12/19/2013 4784678

koos 9 1/4/2010 5456345

4/6/2011 8659635

etc....

Re: Show only the top name

MayilVahanan — Mon, 05 Aug 2013 05:47:07 GMT

Please change straight table to pivot table

PFA

Re: Show only the top name

Mon, 05 Aug 2013 05:50:15 GMT

I can't, i've got about 20 different fields in my actual model, I need to do this without changing it to a pivot table