Qlik Sense Top 10 Ranking

[#1]

Hello

I have couple of questions on qliksense

1. How to show  top 10 customer sales in pie chart or bar chart in Qliksense

2. can we change sheet background with image in Qliksense

3. can we access sheet from another sheet?

4. can we show Tooltip details when we click on city location on map

Thanks

[jeevays7]

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?

[swuehl]

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.

[jeevays7]

Thank you Stefan.

[mukesh19]

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

[zbeauchemin]

Awesome! Thank you Stefan

[sanket94]

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

[anuj_sharma]

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

[naamah]

Hi,

This is realy great!!!!

Can you please suggest how to display top X (depands on user selection) grouped by a category.

Thanks!