Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense Top 10 Ranking

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

17 Replies
jeevays7
Partner - Creator III
Partner - Creator III

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

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
Partner - Creator III
Partner - Creator III

Thank you Stefan.

mukesh19
Contributor II
Contributor II

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
Partner - Contributor III
Partner - Contributor III

Awesome! Thank you Stefan

sanket94
Contributor III
Contributor III

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
Partner - Contributor III
Partner - Contributor III

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
Contributor III
Contributor III

Hi,

This is realy great!!!!

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

Thanks!