Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Re: Qlik Sense Top 10 Ranking

Hi Stefan,

Could you explain above expression?

i.e.

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

Here, =Rank(Sum(Sales))<=10 -> this expression what values will pass and how?


Highlighted
MVP
MVP

Re: Qlik Sense Top 10 Ranking

That's a set expression which filters a set of Customer, selecting Top10 customers with regard to their sales amount ( Sum(Sales) ). Basically all customers pass the filter with a rank(Sum(Sales)) evaluated to <= 10.

Highlighted
Partner
Partner

Re: Qlik Sense Top 10 Ranking

Thank you Stefan.

Highlighted
New Contributor II

Re: Qlik Sense Top 10 Ranking

hi stefan i have only products in a table, I have to count the products and display the top three products in the kpi. could you please help in solving the problem

Highlighted
Partner
Partner

Re: Qlik Sense Top 10 Ranking

Awesome! Thank you Stefan

Highlighted
New Contributor III

Re: Qlik Sense Top 10 Ranking

Hi,

 I have a table . I just wanted to highlight the top 5 values ( Units) using background expression, can you help mw with the expression

Highlighted
Partner
Partner

Re: Qlik Sense Top 10 Ranking

Can you please explain how the expression is working, especially the part highlighted?

How is an output of a condition comparison getting fed to a field?

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

Thanks