Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner
Partner

Bucket Wise Bar Graphs to Show Top 'N'

Hi All,

I have a data sheet (for example) like this below:

SellerSales
Andy100
Smith150
John80
Brent60
Dan200
Scott250
Kenny180
Dick70
Paul90
Bell120
Chris150
Mitchel130
Cook50
Corey210
Bravo140
George240
Mark110
Steve190
Chet160
Peter220
Tom170

REQUIREMENT:

Now in a Bar Graph, I need to show Bucket Wise Data for the Top Seller(Top 1), Top 5, Top 10 and Top 15 Sellers in 4 Bars, and with their Count and % of contribution to the Total Sales (i.e 3070).


Could someone show me with an example with this data? It would be really appreciated.


Regards!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

8 Replies
konstantin
Creator III
Creator III

Check the solution of dynamic top/bottom in the file attached

maxgro
MVP
MVP

like this?

1.png

dmohanty
Partner
Partner
Author

Hye Massimo,

Greetings!

I guess the image you have displayed is my actual solution. many thanks.

Could you please help more on this by sharing the app?

Really appreciated.

dmohanty
Partner
Partner
Author

Hi Kozins,

Thank you.

It helped me somehow, but I wanted my Top 5, Top 10 etc to be clubbed into a single single bar.

Regards!

maxgro
MVP
MVP

dmohanty
Partner
Partner
Author

Many a Thanks Massimo.

It was really helpful. One more request I have, if you can help.

Can it be possible somehow to display the names of the Sellers (somehow) on each Bars.

Something if we hover the mouse or by any means?

maxgro
MVP
MVP

just an idea

1.png

dmohanty
Partner
Partner
Author

Thanks a lot again Massimo for quick help. It was really appreciated.

I will check on your suggestions.

God Bless!!!