Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

top down 10

Hello

i have for example sum(sales) by client

Can i do a top down 10, i mean, not the top 10, just the opposite

Thanks

1 Solution

Accepted Solutions
rittermd
Honored Contributor

Re: top down 10

If you mean the bottom 10 then yes.  You do it the same way just different choice.

6 Replies
passionate
Valued Contributor

Re: top down 10

Hi jeremias,

Do you mean bottom 10?

Regards,

Pankaj

rittermd
Honored Contributor

Re: top down 10

If you mean the bottom 10 then yes.  You do it the same way just different choice.

Not applicable

Re: top down 10

hello, i think is the same, the said to me top down but yes.

How can i do that? i'm new in sense

Not applicable

Re: top down 10

Thanks where i can change that?

Not applicable

Re: top down 10

I have sense in spanish, maybe i have two options "beggining and final" that's the translation to english but i don't think is correct

passionate
Valued Contributor

Re: top down 10

You have multiple options to do this:

=Sum({<Customer = {"=Rank(-Sum(Sales))<=10"}>} Sales)

Use reverse rank.